AnsweredAssumed Answered

supplemental fields not working

Question asked by jimharvey on Apr 18, 2018

When using FMP 10, I used ODBC tables with MySQL databases and was able to use supplemental fields in the ODBC tables. Now I am using FMP 15, and the ODBC tables for the same MySQL sources do not allow supplemental fields. I let FMP 15 convert the .fp7 files to .fmp12 for me, and all of the remote fields come through fine, but the supplemental fields disappeared. Trying to manually add them back to the .fmp12 ODBC tables fails, with the dialog, “This field comes from an unrelated table. Only global fields can be referenced in unrelated tables.”  The table is related, however. So, how do I get the supplemental fields back into the ODBC tables?