Searching Through Multiple Tables

  • Thread starter shiller via AccessMonster.com
  • Start date
S

shiller via AccessMonster.com

Experts,

I just created a database with multiple tables and I'm trying to find a way
to search through them at once. If the parameter is found in table1, form1
will displayed the result. if the parameter is found in table2, form2 will
displayed the results.... What's the best way of doing something like that.

Thanks
 
P

pietlinden

Experts,

I just created a database with multiple tables and I'm trying to find a way
to search through them at once.    If the parameter is found in table1, form1
will displayed the result. if the parameter is found in table2, form2 will
displayed the results....   What's the best way of doing something like that.

Thanks
Click to expand...

If I'm reading between the lines of your post correctly, your design
is wrong. The fact that you want to "search through [multiple tables]
at once" implies, to me, that you have not normalized yet. Post part
of your table structures. Sounds like if you add a "flag" column in
one table, you can just dump all the similar data into the same table
and then your search problem goes away.
 
S

shiller via AccessMonster.com

That was my initial design, one table with a flag column, but the data being
entered is not the same across the board. Flag1 would have columns 1a, 1b, 2,
3, 4 associate with it. Flag2 would have columns 1, 2, 3, 4a, 4b associate
with it... different forms are needed to work with records with Flag1 and
Flag2... That's why I want to put them in separate tables and find a way to
search through them, if the record is found in table1, form1 will display the
results and if the record is found in table2, form2 will display the result.


Please help!

Experts,
Click to expand...
[quoted text clipped - 7 lines]
If I'm reading between the lines of your post correctly, your design
is wrong. The fact that you want to "search through [multiple tables]
at once" implies, to me, that you have not normalized yet. Post part
of your table structures. Sounds like if you add a "flag" column in
one table, you can just dump all the similar data into the same table
and then your search problem goes away.
Click to expand...
 
Top