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