Do you or someone else have control (admin) of the MySQL db?
A view may help give you the data. But you or admin must set this up.
Like FM, MySQL can have permissions down to the column/field level. Perhaps you don't have admin access?
Sent from miPhone
I do not have access to the protected "LastName" field. Otherwise, I have access to all fields (including the "Patient" Table.
1 of 1 people found this helpful
Try deleting the LastName shadow field from the Patient table in FileMaker. This won't affect the MySQL database, but it will prevent FileMaker from requesting the contents of that field.
Also, you appear to be using an old ODBC driver. The supported version for FileMaker Server 16 ESS connections on Windows is MySQL ODBC 5.3 Unicode Driver version 5.3.7.