Just when I think I know what I am doing (on a particular task) I get a curve ball. I have a file where I reconcile a particular general ledger account. This file started in FMP15 now in FMP17. The data is from our accounting system. I decided to make it easier, by having the access to the source files in this table.
Manage -> External Data Sources -> New
Gives me this:
My ODBC connection is set up correctly, as shown in the example on the right. I have other files accessing Great Plains through ODBC. I am not sure how to trouble-shoot this.