I am somewhat new to MS Access and need your help.
I have a form with 3 combo boxes (the record source is a query of multiple tables. The tables are "Business Unit", "Category" and "Product").
The first combo box is "Business Unit" that lists 3 different units "A", "B" and "C". When I select a specific Business Unit - I would like only the categories associated within that Business Unit show up in the next combo box field called "Category".
And then when the Category is selected only have the combo box display Product within that Category.
Is this possible - or what am I doing wrong? I believe I have the relationships setup correctly because when I go into the table itself - there is a plus sign in the column and when I click on it - the correct associated data show up.
Any help would be greatly appreciated!! Thank you!