Jim, the view designer has some major limitations. Develop your SQl in a PRG and then add it to the DBC with Create View...... Be sure you save the PRG, as you cannot open this view with the view designer!
HTH
Barbara
>I am using VFP 6.0 and trying to design a view or query for use in a form. In step 2 of the Local View Wizard (relate tables) I try and add the relationships and get the message "The same table cannot be child for two parent tables".
>
>I have three tables:
>
>Member, Supplier and PO_Header
>
>PO_Header contains the member_no/supplier_no from these two tables
>and I want to display the Member Name/Supplier Name.