On Jan 13, 11:34*am, piper wrote:
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?

No, but it sounds like if your two tables can share a common form,
then all the data should go into ONE table and all you likely need to
do is add a field to your table to differentiate the records.