>
>I've done it once for a wheat merchant, who had four silos with computers on the site - each site was given a characteristic prefix, which prefixed all the PKs of the records they created in all of the tables, and that was used for synchronizing with the central. They also gave temporary IDs (with the same prefix) to their customers (i.e. peasants), and then these temporary IDs were (supposed to be) replaced with regular IDs in the central. There was some two-way updating routine which replaced the IDs in both incoming and outgoing data, which was somewhat tricky to do, but it generally worked. We had much more trouble with bad phone lines and bad floppies than with the logic itself.
>
>HTH
Sounds simple enough. But between the idea and its realisation, sometimes it's good to have Dragan confirm that it's been done.
Thanks. It sure does help.
Marc
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.