AnsweredAssumed Answered

Contacts

Question asked by Marty1 on Mar 28, 2012
Latest reply on Mar 28, 2012 by Marty1

Title

Contacts & Addresses

Post

 Hi,

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

Relation.jpg

Outcomes