>Does anyone have a technique on creating unique ids for tables (as primary >keys) besides the VFP sample that uses NewId()?? > >Our problem is our users want to connect to the data (via drive mapping), >sync their data, disconnect, modify information, reconnect and re-sync >(sending their updates ..and receiving anything new that has changed since >they were off-line). > >Could off-line views be an option(???). offlines views seem like a very good option for this note that to keep the primary keys unique either give a range for each machine or add a machine ID as part of the PK (depending on the data type of your PK) so each record created independently will be unique Arnon