Table question.

[Golfinray]

I have main two forms, one tied to one query, one tied to another. There are
two tables, one supplying each query. There are a couple of fields on each
form that I would like to save in the other table. Yes, I know that you are
only supposed to store data once, but I need the data in the other table for
calculation purposes. So I would like the some info from the one form stored
in both tables and some info from the other form stored in both tables so
that both will be updated and can do proper calcualtions. Am I going about
this correctly, and if so how do I automate this process without having to
stop and run update queries every week or so? Thanks a bunch!!!!

 

[Klatuu]

can't you just use a query that joins the two tables when you want to do
the calculation? If you can determine the correct record to update at data
entry time, you should be able to join the tables at calculation time.

 

[Allen Browne]

You could execute update queries in the AfterUpdate and AfterDelConfirm
events of the form (not controls), but the short answer is that you are
probably going about it the wrong way.

One of the core rules of data normalization is not to store dependent
values. Sounds like you are.