Hi,
I have a feeling this should be simple, but for some reason it has me stumped...
I have the following 2 tables (and fields) :-
tblquotes
QUOTEID
CUSTOMER_CONTACT_ID
BROKER_CONTACT_ID
tblContacts
CONTACTID
Can anyone clarify how I need to lay these out on the relationship window? I just can't get it to work. (I can restructure either table if required.)
Thanks in advance.
I have a feeling this should be simple, but for some reason it has me stumped...
I have the following 2 tables (and fields) :-
tblquotes
QUOTEID
CUSTOMER_CONTACT_ID
BROKER_CONTACT_ID
tblContacts
CONTACTID
- A quote can have just one Customer contact and one broker contact.
- Both Customer and Broker contacts can have multiple quotes
Can anyone clarify how I need to lay these out on the relationship window? I just can't get it to work. (I can restructure either table if required.)
Thanks in advance.