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

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

Post by QW5kcmV3IE » Sat, 09 Feb 2008 01:04:00


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.
 
 
 

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

Post by John W. Vi » Sat, 09 Feb 2008 02:41:50

On Thu, 7 Feb 2008 08:04:00 -0800, Andrew Hollis



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]

 
 
 

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

Post by QW5kcmV3IE » Sat, 09 Feb 2008 03:00:00

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?
 
 
 

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

Post by S2xhdHV » Sat, 09 Feb 2008 04:01:03

Your question was answered in another group. Please don't cross post.
--
Dave Hargis, Microsoft Access MVP
 
 
 

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

Post by John W. Vi » Sat, 09 Feb 2008 04:08:46

On Thu, 7 Feb 2008 10:00:00 -0800, Andrew Hollis



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]