combo box that once item is selected, a new combo box appears

  • Thread starter Thread starter Andrew Hollis
  • Start date Start date
A

Andrew Hollis

I'm trying to create an auto generating drop box on a data entry form. That
is, someone would be entering data that may pertain to more that one project.
I'd like to have a drop down menu that, once a value is selected from it,
another appears underneath, and the user can enter as many projects
as are associated with that data and all this gets saved in the table. I'm
not sure how to do this.
 
I'm trying to create an auto generating drop box on a data entry form. That
is, someone would be entering data that may pertain to more that one project.
I'd like to have a drop down menu that, once a value is selected from it,
another appears underneath, and the user can enter as many projects
as are associated with that data and all this gets saved in the table. I'm
not sure how to do this.
Click to expand...

You'll need a Subform.

You cannot enter many projects into one field. It sounds like you have a many
to many relationship: each <something, your main form's information> can be
related to multiple projects, and each project can be related to multiple
<somethings>. If so you need THREE tables - your main table, a table of
projects, and a third table with fields for the ProjectID and your main
table's ID. You would add multiple records to this third table for the
multiple projects.

John W. Vinson [MVP]
 
hmm. okay, so I'm making a form where people can enter in legislative
revisions. it has info like dates, Federal number, description of revision,
and what regulations are effected by the revision.
The problem I'm having is that each revision may effect one or many
regulations, and I'm not sure how:
1. to have that set up on the form
2. how to have the tables set up
right now I have a table that has all the 1 to 1 things (date, federal
number, etc.) and one that has a list and description of all the revisions.
What would the 3rd table be?
 
hmm. okay, so I'm making a form where people can enter in legislative
revisions. it has info like dates, Federal number, description of revision,
and what regulations are effected by the revision.
The problem I'm having is that each revision may effect one or many
regulations, and I'm not sure how:
1. to have that set up on the form
2. how to have the tables set up
right now I have a table that has all the 1 to 1 things (date, federal
number, etc.) and one that has a list and description of all the revisions.
What would the 3rd table be?
Click to expand...

If each revision can affect many regulations, and each regulation can be
affected by many Revisions, you would need tables:

Revisions
FederalNumber <Primary Key, I am guessing>
RevisionDate
Description

Regulations
<some unique code to identify the regulation that I'll call RegID>
<pages and pages of cryptic legalese description in a memo field>
<any other information about the regulation as an entity>

RegulationEffects
RegID <which regulation is being affected>
FederalNumber <what revision is affecting it>
<fields indicating the nature of the effect of the revision on this
regulation, e.g. EffectiveDate, memo field describing the effect, etc.>

John W. Vinson [MVP]
 
Back
Top