Form ??????

  • Thread starter Thread starter Steve B
  • Start date Start date
S

Steve B

I have 21 separate bill of material tables.I am trying to
design a a form or switchboard that will run a run a query
that I have made.The query runs a comparison on two tables
and identifies differences.The question I have is how I
can create a form or switchboard so that I can have the
user type in the two different models and click on a
button and have it automatically find the two correct
tables to compare and query them????

Thanks ahead of time for any assistance
Steve B
..
 
I think you can certainly hard-code all the tables into the switchboard,
although your description makes me wonder if this is really what you
want to do.
When you said you have 21 tables for bill of materials it immediately
made me think that you need only 1 table with a "code" field that will
be 1 through 21 for different bills. I may be wrong of course but if not
then you might want to get the design normalized before going to
switchboard design.

Best regards,
Pavel
 
Back
Top