Filemaker and MYSQL not updating until I restart filemaker
I have setup an ODBC connection and have connected filemaker with Mysql. I am finding though that If i create a new record in filemaker it updates the mysql database and shows on the internet fine but doesn't show that record in filemaker until i close filemaker and reopen it again.
I have tried refreshing the record and also going into File > Manage > Database and Syncing the database but nothing happens.
Can anyone help please? :)