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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you combine subform data with mainform data? 2
transform data by summing columns 2
Joining Queries 1
Changing Combo Box list when form field changes 4
unique sales order and line number 4
Data Valadation 5
Table design 3
Forms and/or Reports Question 5

Back
Top