>>
>>No, I meant from the table to the view. I think you are right though, you will have problems unless you pull some funny stuff. You can use SETFLDSTATE to trick the view into thinking that the record is not new. VFP uses GETFLDSTATE to determine what records should be updates in an SQL INSERT and which should be updated in an SQL UPDATE. If you change the record's status, it will not try to insert the record, but try to update it, which should be fine.
>
>
>That sounds perfect. I will try the setfieldstate right away.
>
>Thanks
Erik, the suggestion was brilliant and according to VFP documentation should have worked. Unfortunately, while I can use SETFLDSTATE() to set states back and forth between 3 and 4 (both add mode states) when I try to switch the cursor to 1 or 2 I get an error from VFP (Invalid function type or count).
I'm going to a search in the thread on setfldstate to see if anyone has run into this before.
Thanks
Gar
Thanks
Gar W. Lipow