Combo Box sub categories

[workindan]

Hello,

I'm just looking for general table/form design advice.

I'm creating an incident reports database and have a category of 'incident types'. Most of these types are listed as one type, and can thus fit into one combo box for selection, but there are two 'types' which have subcategory options. I was thinking of using a separate (or two separate) drop down boxes, but this seems overcomplicated. In the table, I'll be recording the incident type with two fields: Type and Subtype

I'm open to altering the table or form or both. Any suggestions on design? What's a good approach?

[NTC]

you can display as many columns as you want in a combobox during the users process of selecting a record....just add the columns to the underlying record source query....and remember to widen the property of the control & increase it's column count.

so if the issue is just to give more data so the user can be sure to select the right item - - this is definitely the way to go in terms of ease....