R
ryan.fitzpatrick3
I have a option group for the two database systems my company uses,
lets call them database alpha and database beta. I have a form and a
sub form in that form that is used for manual entry data to collect.
The form would have vendor information, name, contact, address, etc
and the sub form would be the items they supply. This is linked up
properly and is not a concern. The form is linked to a table as well
as the sub form to another table. Would it be easier to have one table
and subtable for database alpha and another for database beta, so the
information doesn't get mixed up? If so, this is where the option
group comes in, how do I, when the user clicks the appropriate
database (alpha or beta) get have the new information that will be
entered in go to the proper table? make sense? basically if they click
database alpha the information entered will go to the database alpha
table and subtable and if they click database beta the same will
happen? Now would an easier way to achieve this is to make a combo box
with the choices, database alpha and beta, and they can click which
they'd prefer and that will record which database is selected, so when
I run a query I can just pick the alpha or beta choice since it's in
one table? What's an easy approach for this?
Ryan
lets call them database alpha and database beta. I have a form and a
sub form in that form that is used for manual entry data to collect.
The form would have vendor information, name, contact, address, etc
and the sub form would be the items they supply. This is linked up
properly and is not a concern. The form is linked to a table as well
as the sub form to another table. Would it be easier to have one table
and subtable for database alpha and another for database beta, so the
information doesn't get mixed up? If so, this is where the option
group comes in, how do I, when the user clicks the appropriate
database (alpha or beta) get have the new information that will be
entered in go to the proper table? make sense? basically if they click
database alpha the information entered will go to the database alpha
table and subtable and if they click database beta the same will
happen? Now would an easier way to achieve this is to make a combo box
with the choices, database alpha and beta, and they can click which
they'd prefer and that will record which database is selected, so when
I run a query I can just pick the alpha or beta choice since it's in
one table? What's an easy approach for this?
Ryan