ODBC MySQL new record disappears straight after adding

[Djvc]

I have set up an MySQL database as an external data source in Filemaker. When I add a new record to it using Filemaker the Found Count briefly increases by one (for about half a second) but then the record seems to disappear. I can search for, and find, the new record in Filemaker but otherwise I have to close and reopen Filemaker to see it. I know there is a Refresh Window option in Filemaker but is there any way of stopping the record from seeming to disappear from view as soon as it is committed by Filemaker?

[Djvc]

I have solved this - the primary key field was set to zerofill so I turned this off which fixed the problem.