Use existing related record when entering in new contact

[Matt P]

Hello,

I am not sure how I can solve this problem. I have a database split
up into three parts. First the company name in tblCompanies, next the
addresses in tblCompanyAddresses, and finally the contact names in
tblContacts. My problem is that I made a form with parts of all three
and so when I go to add a new record it automatically creates new
company records and company address records instead of using an
existing one. I'm sure this is pretty simple but I have been going at
it for a while now and I figure someone could shed some light on this
pretty easily... heres a pic, you'll see how I have it setup:

<a href="http://i39.tinypic.com/14t08dk.jpg">http://i39.tinypic.com/
14t08dk.jpg</a>

Thanks for any input!

-Matt P

 

[KARL DEWEY]

You need to set up form/subform for Company/Contacts using a one-to-many
relationship between the tables.

I never heard of using a separate table for address from a company. Do they
lave multiple operating locations and that is why the split? If so, then you
need form/subform for Company/Location. Then you could have Company/Contacts
or Location/Contacts.

 

[Matt P]

You need to set up form/subform for Company/Contacts using a one-to-many
relationship between the tables.

I never heard of using a separate table for address from a company.  Dothey
lave multiple operating locations and that is why the split?  If so, then you
need form/subform for Company/Location. Then you could have Company/Contacts  
or Location/Contacts.

Ok that actually makes a lot of sense. I already have the one-to-many
relationships setup... I just need to add multiple subforms now. Oh
yeah and by the way in the database it includes many companies with
varying addresses, so that was the reason for the split.

Thanks,
Matt P

 

[Matt P]

You need to set up form/subform for Company/Contacts using a one-to-many
relationship between the tables.

I never heard of using a separate table for address from a company.  Dothey
lave multiple operating locations and that is why the split?  If so, then you
need form/subform for Company/Location. Then you could have Company/Contacts  
or Location/Contacts.

So I am inquiring as to the functionality of this setup. Will the
user be able to update the contact information before the company
name, or they have to fill in the company name and then the address
and then the contact information?

 

[KARL DEWEY]

The company will have to exist before you can give them an address or contacts.