>You could work out of different key pools, or implement a compund primary key, which is a combination of location number and arbitrary integer.
>
>Glenn
>
>>>Check out
SyncData>>Looks like a good idea. Problem is with primary keys. We use primary keys as the way to link records in different files. If 2 offices were working at the same time, adding records to the same dbf, I don't see anyway to keep the primary keys in-synch. I certainly agree that it makes an excellent way to keep an off-site backup.
VFE has the guid() function, which gives you a c(16) hex string, which is supposed to be unique. At least I've never had problems with it. So merging data is no problem.
I've used the SiteID+LocalPK scheme back in FPD days without a glitch. SiteID was just two chars, and LocalPK=substr(sys(2015),3).