>How? In the view, the PK has the value zero, so it is tricky to search for the record. Or do you mean, with requery()?
It's really easy when using a Fox table. The record pointer will be sitting on the newly inserted record.
>BTW, assuming we are willing to upgrade to a later version, do you know how all this would work in a later version, with autoincremental fields? I suspect the value would not be read back to the view, either.
You're correct. The view won't have it until you read it back somehow.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer