×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Re-establishing Existing Relationship

Re-establishing Existing Relationship

Re-establishing Existing Relationship

(OP)
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

RE: Re-establishing Existing Relationship

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

RE: Re-establishing Existing Relationship

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
http://www.accessinsight.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close