Database Sync between MySql and Filemaker
Here is what I am trying to accomplish. We are hosting a website where users will log in and input data and click a submit button. That information will be stored in a MySql database hosted by a third party hosting company. I would like that data to synchronize real time with our Filemaker Datbase located at our office. I would also like any changes made to our local Filemaker Database to synchronize with the MySql database in real time.
I have the ODBC connection and have made a successful connection to the MySql database. We have setup all the Relationships correctly as well, but the synchronization is not taking place. Is there anything I am missing here?
We are using Filemaker Server 10 and Filemaker Pro 10 with all the latest updates. Filemaker Server 10 is residing on a Windows Server 2003 R2 machine and Filemaker Pro 10 is on a Windows XP SP3 machine.