help!!!!!!!!!!!!!!!

[Guest_imported]

i have duplicate records in about 5 tables these records are the same in every table.
is there is a away that when ever a record is changed in one table be updated automatically other tables????
please advice
thanks in advance

 

[tlbroadbent]

How many columns are duplicated in the tables? Are the columns key columns - primary or foreign key? Give some detail about the table structure and exactly what needs to be updated. That info is required to give an appropriate answer.

Welcome to Tek-Tips. I recommend joining. I also recommend that you use a descriptive subject for your posts.

help!!!!!!!!!!!!!!! doesn't tell us anything about your question. It doesn't help us determine if we can help you. Many members skip posts with with similar subject lines.

You are more likely to get a reply if you use a subject like the following.

Automatically update tables when other table changed Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.