I am still confused with FileMaker connecting to my accounting SQL tables. In a new file I created a local table. Then in the Relationship graph, I created the 6 table occurrences that I need to get the data to analyze. I did a query of the data (GL transactions) and I got the correct results (not always the case when I use Crystal Reports). The linked fields all populated correctly. I wrote a couple scripts to Export temp results to Excel and pull back into a stand alone table. This was twice as fast of going from an ODBC table to the FileMaker Table, I suppose for the number of additional fields that I do not need.
I copied the file to the Accounting Managers computer. When he opens it, he is prompted for his password which gives him full-access the same as mine. But then he is prompted for the user-name and password of the ODBC connection. I double checked Manage-External Data Sources. The user-name and password are in the information. I double checked in Administrative Tools to make sure there was an ODBC connection defined in the System Tab, there was.
Nothing was working. I opened a New File. Through Manage-External Data Sources I set up a connection. I was able to make the first two table occurrences for the GLTran and GLNum. And all is fine.
My boss needs to finish the analyses of the inventory account. So I am going to recreate everything when he goes home at 5pm. But I do not understand. The file works for me on my machine. My ODBC connections are defined exactly the same as his. I cloned the file on my machine, to create a new analysis but on prior year history transactions. But if I can not copy the file to his machine and it works, I am spending my wheels.
The FileMaker file is local connecting to the networked accounting files. Nothing is on our FMS. We are using FMP17. Any suggestions will be tremendously appreciated.