Thanks for your help Marcus.

>We use GUIDs instead of number unique Ids. We tried generation with both SQL Server and in VFP, both works for us.
>
>If you really move everything to SQL Server I personally would recommend to place NewID() on SQL Server because this is a bit like "the heart of your data" and if you have it on SQL Server it is in my opinion a bit safer there.
>
>Marcus