Frankly, you are creating a mess! Your tables are not correct.

Post what you want the database to do amd the fields you want in the
database and we will offer suggestions on designing your tables correctly.

Steve



"piper" wrote in message
...
hi, looking for some help, long and winded sorry.
Have a database at present which has table 1 in it and need to add another
table say table 2 which will hold similar info, can I put a combo button
onto
the switch board to choose which table I want the database to use and can
I
switch between the tables to input information? I would like to be able to
pick the table input the info, pick the other table input the info and
then
run querries and reports to obtain relevent information? am I wishing for
too
much?