Contacts & Addresses
I have 2 databases, one to hold contact information, the other to hold an address. The reason for the 2 databases is that some contacts have common addresses, i.e. they share the same office block/ faculty. I wish to create a new contact, then either create a new address for this contact, or select an existing address and associate that address to the contact.
My problem is that after creating the contact, when I go to create a new address a new contact is also created; how do I retain the new address to the current contact, and likewise when I list the addresses I can not seem to select an address to link to a contact.
I show the simple relationship diagram so far