>I am using views

If I'm following you correctly, you're using a view to a table that is using the new autoincrementing field type (eg. VFP 8)? If so, then the problem is that the PK of the view isn't getting populated with the new key generated by the autoinc field-type. So, you're basically attempting to add a new record w/no PK. As far as I'm concerned, there isn't a good way of retrieving this new PK value; use NewID() instead.

If you're not using the new autoinc field, but are using the built-in NewID() stored procedure, I'd look at some of the other suggestions provided already.