>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.

Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)