Updating records

[techkenny1]

Hi all,
In the database I have used this code;
Me.ID = Nz(DMax("ClientID", "tblClient"), 0) + 1 to use as an ID number for clients. I have no problems with this. It works well.
However I now have a requirment to set up this Db in another part of the city.
The front end will be on a work station and the back end on another server.
It is not possible for this other compoany to access the original back end on our server.
The problem I see is in the backup data from server 2 being added to server 1.As we need this info for billing.
If a client has been added in DB2 db and the db is updated there could be a duplication of ID numbers.
Is there a way around this. This problem will also apply to the employees as well.

Many thanks

kp

 

[Savil]

Add another column to the table called Locat or something similar and default the value "A" for location A and "B" for location B then set the primary key for the table to be ID and locat columns. That should do it.