Greetings,

I have a situation where two users have the exact same copy of the same database. When they are out on the field, one user enters in the SiteID field starting 1000 and the other user enters in the SiteID field starting 2000 in AppData table.
They eventually want to get a server and put the back end (table) on a server and the front end in their machines. But my goal for now is when they come to the office to be able to combine both (SiteID) in one database.

Any help would be greatly appreciated!

Create one database out of the two and do replication. You may keep the master and they can syncronize when they are in the office.
Is SiteID an autonumber field? if it is I think that replication does not allow them.




Sal

Autonumbers are allowed, but they will be set to random rather than incrementing.

A better choice would be to use a GUID (replication ID?) as the key field.


Brian Skelton
Braxis Computer Services Ltd.