It seems to me that there is a kind of bug in the Filemaker import strategy.
I have a field "ID" in every table, that is automatically populated by Filemaker with a serial number, that is increased by 1 with every new record.
When I roll out a new version of a database and import the old (live) database into the new one, these serial numbers are not updated with the ones from the live database.
Order::ID in my development version is 11. In the live database it is 416. After importing the live database that figure is still 11. Hence, when a user creates a new order, it is given the ID 11, not 416. Of course this creates lots of problems. Thus I have to update those numbers manually for every table in the database.
Am I missing something or am I doing something wrong or is this not thought through by Filemaker?
Of course I could provide those numbers myself for every new record, but the advantage of having Filemaker populate those fields is, that I don't have to take care of it and it is safer.
I'd be very interested in your views.
Thank you very much in advance