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
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05