Hi, David! Meet David! I just think it's funny when people respond to their own posting. :-)


Here's the solution to your problem:

Kevin has setup a stored procedure that he calls when creating a new record. What you need to do is put "NEWID()" in the default value of your VFP table which should be contained in a DBC. Make sure the PK is updatable in your view.

However, if you don't have your tables in a DBC when you need to over-write the method generating the "NEWID" with your own. I when through these same problems when I was moving an FP for DOS System to VFP.

Hope this helps!