Category and subcategory in the same combobox?

  • Thread starter Thread starter Russ via AccessMonster.com
  • Start date Start date
R

Russ via AccessMonster.com

Ok, my structure is two tables
Table 1-tblCategory
Table 2-tblSubCategory

Example
Table 1-tblCategory = Insurance
Which has these subcategories
Table 2-tblSubCategory = House
Table 2-tblSubCategory = Car
Table 2-tblSubCategory = Boat

Do not want to have 2-comboboxs

What I am looking for is to have the combobox present information like this.
Insurance - House
Insurance - Car
Insurance - Boat

Good idea or bad, any other ideas and or foreseen problems?
 
hi Russ,
What I am looking for is to have the combobox present information like this.
Insurance - House
Insurance - Car
Insurance - Boat
Good idea or bad, any other ideas and or foreseen problems?
Click to expand...
When you really like to use on combo box, then use another format:

House (Insurance)
Car (Insurance)
Boat (Insurance)

I assume in this format it is much more selectiv for the user when he is
entering 'c' as first letter than 'i' in your format.


mfG
--> stefan <--
 
Ok, my structure is two tables
Table 1-tblCategory
Table 2-tblSubCategory

Example
Table 1-tblCategory = Insurance
Which has these subcategories
Table 2-tblSubCategory = House
Table 2-tblSubCategory = Car
Table 2-tblSubCategory = Boat

Do not want to have 2-comboboxs

What I am looking for is to have the combobox present information like this.
Insurance - House
Insurance - Car
Insurance - Boat
Click to expand...

You'll need to join the two tables in a query and use that (or the
corresponding SQL statement) as the RowSource property of the combo.
Good idea or bad, any other ideas and or foreseen problems?
Click to expand...

Without additional knowledge about your application, it is impossible
to say whether or not it is a good idea or bad.

Other ideas: Use two combo boxes and key the second (listing the
subcategories) to the first (main categories).

Foreseen problems: When you get lots of subcategories, it gets harder
to navigate the list.
 
Bob, do you have an example of;
You'll need to join the two tables in a query and use that (or the
corresponding SQL statement) as the RowSource property of the combo.
What do I need to do, something like this?

have a field called; SelectedICategory:[Category] & [Subcategory]


Bob said:
Ok, my structure is two tables
Table 1-tblCategory
Click to expand...
[quoted text clipped - 13 lines]
Insurance - Car
Insurance - Boat
Click to expand...

You'll need to join the two tables in a query and use that (or the
corresponding SQL statement) as the RowSource property of the combo.
Good idea or bad, any other ideas and or foreseen problems?
Click to expand...

Without additional knowledge about your application, it is impossible
to say whether or not it is a good idea or bad.

Other ideas: Use two combo boxes and key the second (listing the
subcategories) to the first (main categories).

Foreseen problems: When you get lots of subcategories, it gets harder
to navigate the list.
Click to expand...
 
Bob, do you have an example of;
You'll need to join the two tables in a query and use that (or the
corresponding SQL statement) as the RowSource property of the combo.
What do I need to do, something like this?

have a field called; SelectedICategory:[Category] & [Subcategory]
Click to expand...

Yes, something like that -- probably more like this:
SelectedICategory:[Category] & " - " & [Subcategory]
 
Back
Top