What type of Action Query would you use?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

troy - 27 Apr 2006 15:20 GMT

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

Reply to this Message

Rick B - 27 Apr 2006 15:47 GMT

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.

Signature

Rick B

>I have several tables and a source table. If any fields are changed in any
>of
[quoted text clipped - 3 lines]
> be
> an update query? Please let me know the best way to handle this. Thank you

Reply to this Message

troy - 27 Apr 2006 16:00 GMT

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

> Why are you trying to maintain duplicate data in more than one table? It is
> rarely a good idea to store redundant information.
[quoted text clipped - 11 lines]
> > be
> > an update query? Please let me know the best way to handle this. Thank you

Reply to this Message