I have 3 columns in tbl_Sales_Details: Product, Range, Outer. How can I realise when product is selected, then available range options shows in the Range Field, and same to 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!