Bill,

Just make sure you don't provide any value for the key when you insert it. I guess the best way to simulate this in VFP would be to create update triggers on your tables that automatically assign a primary key.

>When using a remote view on a SQL Server table that uses automatic primary key assignment, what is the "correct" way to insert records into the remote view before TABLEUPDATE() since the primary keys are unknown? And how should this be handled during prototyping while developing against local VFP tables?