Our database works on and is developed on both windows and mac computers.
I have however a BIG problem with developing an ESS-connection to a web-shop on both platforms.
I can USE the database on both platforms. But I can only DEVELOP on windows, because if I try to develop the database on a Mac the following problem occurs:
When I double click on an ESS-TO in the relations graph, I see the list of the available sql tables, but the corresponding table IS NOT SELECTED.
If I select the table again, FileMaker creates a second shadow table and links the TO to it!
If I then return to windows and look at the TO under windows.
I think it may have something to do with the different drivers we use for the two operating systems:
On the windows computer we use the MYSQL ODBC driver.
On the Mac we use the Actual technologies Open Source Databases ODBC driver.
I cannot find a solution for this problem. Can anybody help?