>I need to create a local view based on 3 tables. Table1 inner join table2 and table1 left join table3. I want to update table3 only. If there is a record in table3 then that record is updated, if there is no record – then insert a new record with an id from table1. I haven’t worked with views since Version 3, please bear with me.
>
>Thank you.
Hi Mark,
First thing you should remember is that you cannot create this kind of view in View Designer. You can create it programmatically but never open in VD after that. You might try to use View Designer just to get the initial SQL, which you then copy from there and experiment with it from code.
Not sure how it is supposed to work with your requirements for Table 3 updates, but may be you can post the table structures here and a sample of the desired result.
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