How to get a drop down list where it will choose the table for the

[kodyw3]

Hello,
I am creating a database, and I need to create a form.
I want to make it so in the form there will be a drop down list (or
something like that) to choose where to enter the data in that form.

Is this possible, if so please help me

respond to me ASAP

Thanks
Kodyw3

thanks

 

[John W. Vinson]

Hello,
I am creating a database, and I need to create a form.
I want to make it so in the form there will be a drop down list (or
something like that) to choose where to enter the data in that form.

Is this possible, if so please help me

respond to me ASAP

Thanks
Kodyw3

thanks

STOP.

If you are requiring the user to choose among multiple (basically identical)
tables in which to store the data, your table structure *IS WRONG*. That's
really bad practice in a relational database! You should instead have *one*
table, with an additional field (you can bind a combo box to that field of
course) to choose which subset of the data.

If you instead want a polymorphic form which can store data in many different
*and differently structured* tables, you're making yourself a whole lot of
extra unneeded work; a better way would be to have a different form for each
(different) table, and a switchboard to bring up the proper form.

The tables and their relationships are fundamental! What are your tables? How
are they related (if at all)? Get those issues fixed before you start worrying
about forms!

 

[Jeff Boyce]

Everything John said, plus ...

Do you really want your users deciding where to stick stuff? Do they
understand relational database design well enough to trust them not to stick
things where they shouldn't be?

Do you feel lucky?

Regards

Jeff Boyce
Microsoft Office/Access MVP