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.