Yes I agree that this is a much better solution.
>>FYI the tricky part when I did it a few years ago was the primary keys...if the road-bound person is going to be ADDING data then you need to set it all up so they have their own set of primary keys...it's not overly complicated I just started them out at a high number.
>
>I didn't really had the need to do this yet, but I think several alternatives to the solution you propose are available, for instance:
>
>
Use two fields for the PK. One is the user number (each user has to be assigned a unique number), the other one, a sequential number.
>Same as above, but combine into a single field with bintoc(gn_UserId,2) + bintoc(SerialNumber("TableName")).
>Use a GUID as a PK.
ICQ 10556 (ya), 254117