Combo Boxes Values

[ahmadrashid17]

Till now i have done the following work:

Table1: Category
Table2: SubCategory
Table3: Item

Category has CategoryID, Category
SubCategory has SubCategoryID, SubCategory, CategoryID
Item has ItemID, SubCategoryID, ItemName, ItemPrice

Relationships are also done.

I have designed a form for Item where the user has to select Category on the basis of which SubCategory drop down filters using the where clause and assign the value of Category DropDown in the form. (forms!frmItem!cmb_Category)

Then In After Update event of Category DropDown I have requery the SubCategory DropDown.

Now User can easily insert the records. The problem is when the user navigate through the records. The Category DropDown which is not a bound column in Item form, can not get the selected Category for the SubCategory being entered for the Item.

How can I solve this problem. When the user navigate, the Category DropDown must display the category relative to the SubCategory of the record.
I need your expertise in this regard

 

[Dennisk]

A common problem, I would store both the category and sub category.

 

[CEH]

In other words, the combos should be bound.

 

[Dennisk]

Yes, but to do that you need to store both IDs