If we cannot use the view designer to change this view, then how does one set the update criteria? The user needs write access to two of the fields in the view. Can update criteria be set from code?

Thanks for your help.

--Chris

>Chris ---
>
>View Designer chokes on multiple JOINs. Try the following:
>

>CREATE VIEW myview AS ;
>   SELECT orders.*,orditem.*,porditem.*,invitem.* FROM orders ;
>      LEFT JOIN orditem ON order_id+ord_line_no/100 ;
>      LEFT JOIN porditem ON porder_id+pord_line_no/100 ;
>      LEFT JOIN invitem ON invoice_id+inv_line_+no/100
>

>You cannot modify this view in the View Designer, either. If you have to recreate it, do it in code. Good luck!
>
>
>
>
>
>>I am trying to create a local view and having problems. VFP sometimes can create the view but later when I try to look at the resulting view (through MODIFY VIEW) I get unintelligible error messages. The tables involved are straightforward: order, order lines (orditem), purchase order lines (porditem), and invoice lines (invitem). The relationship is 1:M:M:M; i.e., one order can have multiple lines, one order line can relate to multiple purchase order lines, and one p/o line can relate to multiple invoice lines. The key fields in the tables are:
>>
>>order: order_id
>>orditem: order_id + ord_line_no/100
>>porditem: porder_id + pord_line_no/100
>>invitem: invoice_id + inv_line_no/100
>>
>>Assuming all fields of all tables are desired in the view, how should the code be written? For example,
>>
>>create sql view test as;
>> select * from order inner join orditem;
>> on order.order_id = orditem.order_id;
>> ...
>>
>>How to finish this code?
>>
>>Thanks in advance.
>>
>>--Chris Lawrence