Many To Many Relationship

[midovicchajy]

I have amain Form Called " Customer " and 2 SubForms
First Called "Contacts"
Second Called " Contact Details"

Every Customer Have and Unique ID
Every Customer Have Multi contacts
Every Contact Have Multi Way To contact ( Multi Phone ( Continous SubForm) , Multi E-mail( Continous SubForm) , )

Best Way To do this What in RelationShip
I want Each customer Have Multi contact
then when I change contact Changes The subforms ( phones and e-mails )



Any Ideas Or Help Please

[ssanfu]

This is how I would set up the tables/ forms:


tblCustomers
==========
CustomerID_PK (unique ID - usually Autonumber)
CustLastName
CustFirstName
'other info

tblPhoneNumbers
==============
PhoneNumberID_PK (Autonumber)
CustomerID_FK (Long) [Foreign key to customer]
PhoneNumber )Text)
PhoneType (Text - ex. Home/Cell/Fax/etc)
'other fields as required/needed

tblEmailAddresses
=============
EmailAddressID_PK (Autonumber)
CustomerID_FK (Long) [Foreign key to customer]
EmailAddress (Text)
EmailComment (Text)
'other fields as required/needed



Main form record source would be query based on tblCustomers.
Sub form 1 record source would be query based on tblPhoneNumbers.
Sub form 2 record source would be query based on tblEmailAddresses.


Main form detail section - customer info
Main form footer has the two sub forms
Set Master/Child links to CustomerID_PK/CustomerID_FK for each sub form.