change data in table

  • Thread starter Thread starter bbypookins
  • Start date Start date
B

bbypookins

I have a one to many table that lists of our company divisions and
sub-divisions. We just went through a re-organization and the names and
corresponding unit number have changed. How do I change this in the
tblUnitNames+Numbers and have it reflect in all the records that are related?
 
Go to the Relationships window. Are the tables joined there? If so is
Referiential Integrity enabled with Cascade Update?

If Cascade Update is enabled AND we are talking about the primary key /
foriegn key fields, changing the PK data should update the FKs.

Soapbox mode on: This is why I tell people to use autonumbers as the primary
key. They don't have any 'meaning' and therefore never need changing.
Soapbox mode off:
 
Back
Top