Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Re-establishing Existing Relationship

Status
Not open for further replies.

MustKnow

MIS
Jun 18, 2001
1
US
Hello,

I'm trying to change data in a table that has a one to many relationship with about 15 other tables.  The problem is, I can't change data in the master table because of the preexisting relationship that already exists.  Is there a way to temporarily remove an existing relationship, change the data you want, and then reestablish it later without destroying or losing data?  Another challenge I'm facing is the fact that since I didn't design the database, I have to be careful of what I change since there is little to no documentation.

Thank you for your imput,

MustKnow
 
If the relationship on the table has Cascade Update Related Fields checked in the join within the relationship window you can change the data in the master table and Access will "automagically" update every record in every table related to the master. Make sure you backup your database before trying this!

HTH Joe Miller
joe.miller@flotech.net
 
And just to add to that... The thing that gets the cascading update is the primary key value. This won't work if the primary key is an autonumber. Let us know if this is not what you needed!

Pamela
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top