Multiple Dependent Drop Down Menu?

  • Thread starter Thread starter Tommy Ahati
  • Start date Start date
T

Tommy Ahati

I'm trying to create a form based off a table that has a pool of all the
courses available in the school. The form should help me plan what courses I
need to take. However, I'm finding a hard time with later courses that
require pre-requisites. For example, Biochemistry 1 Requires you to have
previously taken Chemistry 1 and Biology 1.

So I want to know how to make a Form that has 5 Dropdown Menus for classes
you can take that change depending on previous drop down menus from previous
semesters.

I'm totally stumped!

--
Sophomore Triple Major
-Business Administration (Finance, Operations Management, Management Info
Systems)
-Biochemistry (Cell, molecular, and Genetics)
-Computer Science and Math.
 
Tommy said:
I'm trying to create a form based off a table that has a pool of all the
courses available in the school. The form should help me plan what courses I
need to take. However, I'm finding a hard time with later courses that
require pre-requisites. For example, Biochemistry 1 Requires you to have
previously taken Chemistry 1 and Biology 1.

So I want to know how to make a Form that has 5 Dropdown Menus for classes
you can take that change depending on previous drop down menus from previous
semesters.

I'm totally stumped!
Click to expand...

Is this any help?

http://office.microsoft.com/en-gb/access/HA011730581033.aspx?pid=CL100570041033

Phil, London
 
I've found numerous examples but... I still can't seem to make a pretty large
form for 14 semesters, each semester with 5 slots. So that's a LOT of
choices!

Is there an easy way to do this?
--
Sophomore Triple Major
-Business Administration (Finance, Operations Management, Management Info
Systems)
-Biochemistry (Cell, molecular, and Genetics)
-Computer Science and Math.
 
I'm trying to create a form based off a table that has a pool of all the
courses available in the school. The form should help me plan what courses I
need to take. However, I'm finding a hard time with later courses that
require pre-requisites. For example, Biochemistry 1 Requires you to have
previously taken Chemistry 1 and Biology 1.

So I want to know how to make a Form that has 5 Dropdown Menus for classes
you can take that change depending on previous drop down menus from previous
semesters.

I'm totally stumped!
Click to expand...

Turn your viewpoint around; it sounds like you're trying to search for data on
Forms and in "previous drop down menus". Data is NOT stored in forms or in
combo boxes, but in Tables! What is the actual design of your tables? How are
they related? How do you encode prerequisites in your Courses table?
 
Well I have a Table Called "CoursePool" which is organized with the
respective Columns
-Course_ID (i.e. MA124, MA152, CH102, EN101 etc...) this has an input mask
of 2 letters and 3 numbers
-Course_Name (i. e. Linear Algebra, Multivariable Calculus, Organic
Chemistry etc..)
-PR1 (Respective Prerequisite Class with the same Input Mask as Course_ID)
-PR2 (2nd Respective Prerequisite Class with the same Input Mask as Course_ID)
-PR3 (3rd Respective Prerequisite Class with the same Input Mask as Course_ID)

--
Sophomore Triple Major
-Business Administration (Finance, Operations Management, Management Info
Systems)
-Biochemistry (Cell, molecular, and Genetics)
-Computer Science and Math.
 
Back
Top