Relationship question

[Steven811]

Hi

I attach the db I thought I'd sorted, fool that I am. I want to able to have the following relationships:

One customer to many sites
One site to many quotes
One site to many contacts yet each contact will be unique

and the problem relationship,

one contact to many quotes

When I set the relationship up to the site it works fine, I'm just unsure how to handle the one contact to many quotes.

When it is complete I would like to be able to link each contact with their quotes and each site with their related quotes.

Could anyone put me straight please.

Thanks

Steven811

 

[Steven811]

Thanks

I will change the relationships and try again.

Steven811

 

[Steven811]

Tried again

I thought I had solved the problem by implementing what you had suggested, but I can't add a contact as an entry is required in tblJobTracking. I seem to be going around in a circle getting nowhere fast.

New fields in tbleJobTracking have become indexed, which I half understand. I thought that tblJobTracking tob was automatically provided with an autonumber entry when a record is added in a related table.

I enclose my revised db if anyone could help me with my problem before my head explodes.

Steven811

 

[Steven811]

Thanks

I am now working on your suggestions.

Steven811