Charlie,

>>IMO, you can build much more useful business objects in VFP by using subclasses of the stock cursor and data environment objects...

Sounds like a nice system. FWIW, I've written a set of SQL interpreter classes that take a T-SQL command and add VFP variations as required. Different ways of achieving the same end.

>>Also, whether its VFP or SQL Server, validating and generating primary keys in the business layer is not a good idea. IMO, this kind of stuff belongs with the data.

I presume you've got stored procedures in the data tier that generate the new primary keys. Lacking those stored procedures, I would say the primary key should be developed in the business tier.

Regards,
Thom C.