Change specific records' values

[Matt P]

Hello, I have a database split into 3 main tables.
tblCompanies (all of the company names)
tblAddresses (all of the address, this was made because there are
multiple addresses sometimes for the same company
tblContacts (which includes all of the info about the contacts)

Now here is the problem I am facing, which I thought I had all figured
out. I setup a form that includes information from all of these
tables. Now I knew when someone was going to try and change lets say
for instance the name of the company, it would change it for all of
the other contacts that shared the same company name. So I added a
combo box and bound it to a field from tblAddresses called "CompanyID"
which has a relationship with the ID field of tblCompanies. The next
one is a combo box bound to a field in tblContacts called "AddressID"
which is related to the ID field in tblAddresses. Now the problem is
that when you try and change the company name it changes all of the
contacts under that address to the updated company name.

Anyone have any ideas how I should go about solving this?

 

[Matt P]

Hello, I have a database split into 3 main tables.
tblCompanies (all of the company names)
tblAddresses (all of the address, this was made because there are
multiple addresses sometimes for the same company
tblContacts (which includes all of the info about the contacts)

Now here is the problem I am facing, which I thought I had all figured
out.  I setup a form that includes information from all of these
tables.  Now I knew when someone was going to try and change lets say
for instance the name of the company, it would change it for all of
the other contacts that shared the same company name.  So I added a
combo box and bound it to a field from tblAddresses called "CompanyID"
which has a relationship with the ID field of tblCompanies.  The next
one is a combo box bound to a field in tblContacts called "AddressID"
which is related to the ID field in tblAddresses.  Now the problem is
that when you try and change the company name it changes all of the
contacts under that address to the updated company name.

Anyone have any ideas how I should go about solving this?

Nevermind I figured out where I was going wrong..