limiting the population of a combo box...

[srmousse]

This is a little complex, I will try to explain as best I can...

I have several tables, storing businesses, business types, and categories... now, each business has between 3-7 categories, the categories are determined by the business type. here is how my tables are setup:

tblBusiness
-BusID
-BusTypeID
-BusInfo (several fields)

tblBusType
-BusTypeID
-BusType
-BusTypeInfo

tblCat
-CatID
-CatName

tblBusCat
-BusID
-CatID
-Value

tblBusTypeCat
-BusTypeID
-CatID

On the form I have the all of the Business info, then a subform with the BusCat info to fill the values of the Categories that relate to the businesses. The purpose of the final table (at least I was hoping) was to populate the Available Business Categories in this form and on my reports, basically limiting the categories available to a business via it's business type.

Currently I had created a second subform within the original form and set it as uneditable in order to Display the categories associated with the business type, however my system will be SO much more functional if I can find a way to limit the options as previously stated.

Thanks so much for your help, I hope I haven’t confused everyone.