RCheesley
Registered User.
- Local time
- Today, 03:41
- Joined
- Aug 12, 2008
- Messages
- 243
Second time lucky, my previous post timed out
I wondered if I could get some suggestions on the best practice for displaying cascading combo boxes.
I have some categories, say 1,2,3,4,5 and within these are sections, say 1a, 1b, 2a, 2b and so forth.
I want to have a combo box on a form where the user can select the category, then the section within become available on a second combo box for selection.
How would I best store the categories/sections? I had thought about a table with ID | Category | Section but this would mean duplicating quite a bit on the Category field - would two tables be better?
I am assuming each combo box will need a query - one which queries the category and the other the section, but how best to conditionally link the two?
For information I am using Access 2003, and have a basic understanding of access/vba/sql so fairly basic explanations would be really helpful
Many thanks in advance,
Ruth
I wondered if I could get some suggestions on the best practice for displaying cascading combo boxes.
I have some categories, say 1,2,3,4,5 and within these are sections, say 1a, 1b, 2a, 2b and so forth.
I want to have a combo box on a form where the user can select the category, then the section within become available on a second combo box for selection.
How would I best store the categories/sections? I had thought about a table with ID | Category | Section but this would mean duplicating quite a bit on the Category field - would two tables be better?
I am assuming each combo box will need a query - one which queries the category and the other the section, but how best to conditionally link the two?
For information I am using Access 2003, and have a basic understanding of access/vba/sql so fairly basic explanations would be really helpful
Many thanks in advance,
Ruth