Custom View & Linked Table for Master/Detail

Linked tables do not appear in the list of available tables when creating views or custom views

  1. You cannot create view or Custom View across databases.
  2. However, if you use MySQL and the tables are from databases in the same server, you can still create a view, google “Performing a Join Between Tables in Different Databases”.
  3. Avoid Custom View, see the topic “Using Custom View” in the help file.

Unfortunately tables are on different servers :frowning: