prameetghosh87
New Member
- Joined
- Aug 25, 2020
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Background: We have database where we maintain brands and product details. There are around 20000 brands and around 30000 products. Please refer the image for sample data.
Question: We have now got some 100 brands. We need to check if they are present in the list of 20000 brands and display all similar brands in the drop-down list. For example, if user enter "ABC" brand, we should display brand starting with ABC in the drop down. In our case, it will be ABC, ABC Pro and ABC Plus. Now if the user selects "ABC Plus" under Brand field, we need to display corresponding product (ABC Plus 20 packets and ABC Plus 30 packet) in the drop down under Product field
Can anyone please help me with request.
Question: We have now got some 100 brands. We need to check if they are present in the list of 20000 brands and display all similar brands in the drop-down list. For example, if user enter "ABC" brand, we should display brand starting with ABC in the drop down. In our case, it will be ABC, ABC Pro and ABC Plus. Now if the user selects "ABC Plus" under Brand field, we need to display corresponding product (ABC Plus 20 packets and ABC Plus 30 packet) in the drop down under Product field
Input | Brand | Product |
ABC | Drop-down will show brands with name starting with ABC. In our case it will be ABC, ABC Pro and ABC Plus | Drop- down will show corresponding product selected in Brand category. |
DEF | Drop-down will show brands with name starting with DEF. In our case it will single entry - DEF. | Drop- down will show corresponding product selected in Brand category. In our case, it should be "DEF 10 packet". |
XYZ | Drop-down will show brands with name starting with XYZ. In our case it will single entry - XYZ | Drop- down will show corresponding product selected in Brand category. In our case, it should show two values - "XYZ 20 packet" and "XYZ 40 packet". |
Can anyone please help me with request.