Relating more than one foreign key

Hi Doug,

Thank you for the quick reply - I really need to solve this before progressing.

BTW, according to a book I have 'Access 2002: The complete reference' it's normal to have two 'copy' instances TBL_STORES_Contacts_1 & /2 as shown in RelationshipWindow.gif. I'll follow your suggestions however.

Relationship window:
TRIAL 1: I deleted the two 'copy' tables TBL_STORES_Contacts_1 & /2, saved the relationship layout and closed the window.
On opening again, the same two tables were there again with their original relationship line! I deleted them again
TRIAL 2: Now I try to create a relationship between ID_Contact (in TBL_STORES_Contacts) and Contact_ID_Delivery (in TBL_STORES_Orders)
The following message appeared: "A relationship already exists. Do you want to edit the existing relationship? To create a new relationship, click no"
I clicked yes and added the new relationship in the popup pane. A warning appeared saying Access can't enforce referential integrity: I have no choice but to remove referential integrity.
Now there are 3 relationship lines from ID_Contact (in TBL_STORES_Contacts) to TBL_STORES_Orders' fields (Contact_ID_ ... Confirmation, Delivery & Invoice).
I saved the relationship layout, closed then reopened the relationship window.
Now there are 3 more tables appearing: TBL_STORES_Contacts_1/2/3 each with 3 relationship lines from their ID_Contact field - very messy and surely not correct? I managed to delete them all again to get back to just one relationship line from ID_Contact (in TBL_STORES_Contacts) to Contact_ID_Delivery (in TBL_STORES_Orders).
TRIAL 3: I repeated the procedure in TRIAL 2 except after the message from Access I chose 'no' (create a new relationship). I now have 3 relationship lines from ID_Contact (in TBL_STORES_Contacts) to TBL_STORES_Orders' fields (Contact_ID_ ... /Confirmation, /Delivery & /Invoice).
I saved the relationship layout, closed then reopened the relationship window. The layout has been kept!
I had to refuse referential integrity - isn't this a problem?

I examined the Lookup fields in TBL_STORES_Orders - all the Lookups are as before (nothing to change)

Query:
If I create the query again as shown in my first screen shot (QueryDesign.gif) I have the same issues:
1. Not all orders show - the ones missing are those where the contact for Confirmation, Delivery and Invoice are NOT all the same
2. I still need to include the fields from TBL_STORES_Contacts 3 times in the query enabling me to display the 3 contact possibilities on the customer report - so the customer can see who receives the confirmation, delivery and Invoice

Best regards.
Joe