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
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