I have 3 columns in tbl_Sales_Details: Product, Range, Outer. What I want to realise is that when product is selected, then available product range options shows in the Range Field, and then depending on the range selected, relevant outer options show in the the Outer Field.
For example:
when I choose Pepsi, the available 3 options (Original/Diet/Zero) shows in Range, and then according to RangeID, available options of Outer shows in dropdown list for selection.
Can it work out without using VBA? If not, would be appreciated to have the code.
Please help!
For example:
when I choose Pepsi, the available 3 options (Original/Diet/Zero) shows in Range, and then according to RangeID, available options of Outer shows in dropdown list for selection.
Can it work out without using VBA? If not, would be appreciated to have the code.
Please help!