As a query, try using the PO_Header table as a linking table in a cascaded relation:
select (fields list);
from Member;
INNER JOIN PO_Header ON Member.membername = PO_Header.membername;
INNER JOIN Supplier ON PO_Header.suppliername = Supplier.suppliername;
...(remainder of query)...
I believe the same principle will apply in your view, by setting relations between Members to PO_Header, then between PO_Header to Suppliers.
(Code sample is for concept only and may not be syntactically exact.)
Cetin Basoz helped me sort this out in his message to me:
Re: Misbehaving query Thread #
248195 Message #
248214 on 30/07/1999
HTH....
Good luck
Neil Preston
>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.