simplilfying my database

  • Thread starter Thread starter Allen Blevins
  • Start date Start date
A

Allen Blevins

I have multiple queries that do the same thing.

query1 does a find and update on table1
query2 does a find and update on table2

query1 and query2 are doing the same thing.

is there a way to have just 1 query do a find an update to both table1 and
table2?
 
No.
But you could create a form with a button on it that triggers a macro
(OnClick property) that would run both queries with one click.
 
I have multiple queries that do the same thing.

query1 does a find and update on table1
query2 does a find and update on table2

query1 and query2 are doing the same thing.

is there a way to have just 1 query do a find an update to both table1 and
table2?
Click to expand...

Not at all easily... but this situation should not come up in a properly
normalized database! Having two tables of identical structure, or storing "the
same kind of data", is not correct normalization. What is in these tables, and
how do they differ? Could they be coinsolidated into one larger table with an
additional field to distinguish the two subsets of data?
 
Back
Top