hi,
im am trying to limit the content of a combo box based on a selection in another combo box.
i have two tables called "Categories" and "Products".
the fields in categories are
-CategoryID, CategoryName.
the fields in Products are
-ProductID, Brand, Model, etc
i have two combo boxes "Category" and "Product".
what i want to do is allow for a selection to be made in "Categorys". And limit the selection in "Products" acording to the first combobox.
eg.
Speakers
-sony
-kenwood
Labor
-setup
-repair
can someone please help it would be much appreciated.
im am trying to limit the content of a combo box based on a selection in another combo box.
i have two tables called "Categories" and "Products".
the fields in categories are
-CategoryID, CategoryName.
the fields in Products are
-ProductID, Brand, Model, etc
i have two combo boxes "Category" and "Product".
what i want to do is allow for a selection to be made in "Categorys". And limit the selection in "Products" acording to the first combobox.
eg.
Speakers
-sony
-kenwood
Labor
-setup
-repair
can someone please help it would be much appreciated.