Hi bob,

>Because autoincrement should be a feature of the data engine and should work totally seperatly from an application.

>This is espesially important when your data is being accessed view ole-db or odbc or by some cowboy with a copy of VFP.

What is wrong with havingthe logic as a stored procedure and having the defaultvalue property of the PK field set to NewKey("Foo_pk") ?

Walter,