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
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
