View Full Version : Cascading combo problem


andyh
09-21-2000, 03:25 AM
Firstly thanks for any input into this problem.
I am sure that there is an easy solution (but only if you know how!)

I have a form in which i would like 2 combo boxes to work from each other.

In the first box i want the user to select from a list of 20 categories. then, based on the select, the second combo will display all the relevant questions (approx 20 in each category) for the user to select.

Question:
How should I hold the 400 questions in a table? Do i need to have 20 tables - 1 for each category or all in a single table?

Then, once I have my Table(s) how do set up the cascading combos ???

do I need to point the combos to the query holding other info or directly to the table(s)?

All info (in PLAIN english) is much appreciated...

thanks