Maintain updated master table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 46 individual tables representing readings for different emission
points. I also have a master table that I'd like to append to daily. There
can be up to 9 new readings per table per day. How can I write a query that
updates the master table from each of the individual tables?
 
Not sure why you would have 46 tables that store the same type of data and
then a master table that duplicates all that. What is different about each
of the 46 tables? It sounds like it would be much better to get rid of all
of them and have ONE table (your master table). You would need to add a
field to represent the "source" or "type" or whatever the various tables
told you. So, if table 1 was readings for "reactor 1" and table 2 was for
"reactor 2", then you simply need a "reactor" field in your master table.

Post back more details if you still feel you need 46 tables to track similar
data. Is the structure of each table drastically different? If so, do you
only transfer a few fields to your master table?

A few more specifics please.
 
In hindsight, it was very poor design on my part. This is the first real
project I've been tasked with, so I'll blame inexperience. The pickle I'm in
is that I have forms for user input (1-6 tables on each) with working code
associated with each. If I change the control source on the forms, I get
#Error in the text boxes. If I enter code to make the master table equal the
value entered for the field, I get an error. I'm sure the answer is simple,
but I haven't found the logic yet.
 
Back
Top