Linking Clients and Client Contacts to Addresses

[harringh]

Hi,

I am building a client database and Im having an issue with linking tables in relation to clients and their addresses.

I have a clients table which stores data on each client (or company). For each client there are a number of client_contacts. This is a many-to-many relationship so I have a link table between the two tables.

I also have an address table. I need to store the addresses both of clients and client_contacts. This address might be the same, but it might be different, e.g.

Client: Company A
Client_Contacts: Helen Smith
Joe Bloggs

Address of Company A: 101 Main St
Address of Helen Smith: 101 Main St
Address of Joe Bloggs: 23 South St

My issue is how to link the Clients and Client Contacts tables to the addresses table?

Any advice would be appreciated.. this has me confused for a while!

Thanks

 

[vbaInet]

These links may provide some insight:

http://allenbrowne.com/AppHuman.html
http://allenbrowne.com/ser-06.html