Tables and info

[piper]

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?

 

[Piet Linden]

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 canI
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 fortoo
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.

 

[Steve]

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
(e-mail address removed)

 

[piper]

Thanks will have a shot at this.

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.
.