CheckBox Processing

[Michael]

Hi Folks - Access 2000 .... I currently have a combo box form field that
displays 4 categories: Science, Math, English, History. The original specs
indicated that a teacher would be assigned to only ONE category. However,
the specs have changed. Now, it turns out that a teacher can belong to more
than one category. This category choice is the criteria for numerous
queries. I'm trying to figure out the best way to make the change.

My first thought is to make a related table, then add a subform that will
allow multiple categories to be assigned to the teacher. I would then need
to change all the current queries to accommodate the related info.

I think a more elegant solution would be to use checkboxes. However, I'm
having a hard time conceptualizing the processing of the checkboxes, and
what changes would be necessary to the current queries. Any thoughts?

 

[Rick Brandt]

Hi Folks - Access 2000 .... I currently have a combo box form field that
displays 4 categories: Science, Math, English, History. The original specs
indicated that a teacher would be assigned to only ONE category. However, the
specs have changed. Now, it turns out that a teacher can belong to more than
one category. This category choice is the criteria for numerous queries. I'm
trying to figure out the best way to make the change.

My first thought is to make a related table, then add a subform that will
allow multiple categories to be assigned to the teacher. I would then need to
change all the current queries to accommodate the related info.

I think a more elegant solution would be to use checkboxes. However, I'm
having a hard time conceptualizing the processing of the checkboxes, and what
changes would be necessary to the current queries. Any thoughts?

Your first thought is the more elegant solution. The second option would be bad
design. It would introduce the same problem of flexibility that you face now.
If you have 6 CheckBox fields because there are currently 6 classes then you
have a redesign requirement every time the number of classes changes.

Stick with the second table and subform idea.