What type of Action Query would you use?

[Guest]

I have several tables and a source table. If any fields are changed in any of
the 4 tables. I want it to update the source table with the new infomation.
Would this be an Update query or and Append query? I would think it would be
an update query? Please let me know the best way to handle this. Thank you

 

[Rick B]

Why are you trying to maintain duplicate data in more than one table? It is
rarely a good idea to store redundant information.

Also, if the four tables have the same structure, but different "types" of
data, they should probably be stored in one table with a new "type" field.

Post back with more details and perhaps we can help you normalize your data.

 

[Guest]

Rick,

Here is what I am up against. I took this contract job and have 4 weeks to
complete.
This is a database that is a total mess with approx 5 other databases
connected to it then 4 of them or on SQL. This paticular one has over 60
action queries all macro driven. I have fixed approx 30 of them but.. So I am
not in a position to restructure this thing because I am pressed for time big
TIME. Anyway all they want is if any filed that I put in my query are changed
they want it to change in there master table. At this pint I am not going to
argue with them. What is the best way to handle this?

4 source tables and approx 18 different fields
If any of those fields change they want it to update the SQL database.
Please advise