I'm using for several years, an external data source in my company via odbc.
I don't remember the FMP version I used to begin with this, but it works perfectly with FMP 14 client. (currently, client FMP 14, FMP server 15, on pc windows or Citrix)
Something strange happens when I test FMP 15 or FMP 16 client, with the same file on the same FMP server 15
At the file opening, the link doesn't work.
If I open the manage database window and click anywhere in the relationships tab,
the link is restored!!! and works properly.
At the next opening, the problem is back (remember that it doesn't appear with FMP 14 client)
Any idea to understand and solve it?