Cascading combo/query in tables

Joined
Sep 21, 2017
Messages
2
Reaction score
0
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!
 

Attachments

  • DB1.zip
    27.7 KB · Views: 168

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top