Limiting the population of a combo box....

S

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.
 
Top