If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Tables and info
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? |
#2
|
|||
|
|||
Tables and info
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. |
#3
|
|||
|
|||
Tables and info
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? |
#4
|
|||
|
|||
Tables and info
Thanks will have a shot at this.
"Piet Linden" wrote: 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. . |
Thread Tools | |
Display Modes | |
|
|