Hi,

I have an MySql database and six users who access the database via a Delphi front end. The users need to download a copy of the db, make modifications, then upload. The question is that when they add a record (which will increment the customerID for example) and upload it how can I take care of the issues of having multiple records with the same ID number and thus causing an error.

Many thanks,

Jo

Generally you give each user a unique valid range of customerIDs. User 1 has values 1 to 1000, User2 values 1001 to 2000 and so on. In this way you can avoid the conflicts you are encountering.

Best I can come up with for this problem.

Hi Certus,

Many thanks for the help, it seems the most logical way forward and easy to implement.

Many thanks