>>>I have a form where I create a history using an INSERT INTO a view. Immediately after doingt so I would like to store the cid that was created in the dbf file for later use. How might I go about doing that?
>>>
>>>Thanks.
>>
>>If your cid is generated in DBF you may REQUERY() your view to get ID assigned to INSERTed record, if it's what you mean.
>>
>>Nick
>
>Yes, but how can be sure that I am on the same record?
Well, if you have a parameterized view with one record (like me) it is not a problem, but if there are more you have to LOCATE your record after Requery().
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison