Integrating tables and forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to create a user input form. I want one of the fields on the form to
be a Combo Box in which the combo box choices are populated from an existing
table. I then want the choice that the user selects to be populated in a
different table that has pre-existing data.

A couple of complicating factors in this database:
1. There are multiple tables that the form will have to dump data into.
2. There are multiple tables (different from the ones above) that the form
is using to determine selection options for each field.
3. The form is run off a differnent table -- all the tables that are using
to store user-entered data are connected by one field in the relationship
view.
 
BLV 06 said:
I need to create a user input form. I want one of the fields on the form to
be a Combo Box in which the combo box choices are populated from an existing
table. I then want the choice that the user selects to be populated in a
different table that has pre-existing data.

A couple of complicating factors in this database:
1. There are multiple tables that the form will have to dump data into.
2. There are multiple tables (different from the ones above) that the form
is using to determine selection options for each field.
3. The form is run off a differnent table -- all the tables that are using
to store user-entered data are connected by one field in the relationship
view.
Click to expand...

Sounds like a grungy mess. Something this yucky almost invariably results
from poor data design. If you were to post details of the business
scenario, then someone will doubtless advise on how to do it better.
 
Back
Top