I know how to create a dependent dropdown list of my data is presented this way.
But I need help in dependent validation if the data is presented this way.
This is because this is going a continuous list and data needs to be presented this way because the other columns next to it has data that cannot be dynamic.
Thank you in advance.
| Vegetable | Fruits |
| Potato | Apple |
| Tomato | Orange |
| Spinach | Banana |
| Onion | Kiwi |
But I need help in dependent validation if the data is presented this way.
| Model No. | Variant |
| CU1234 | Black |
| CU1234 | White |
| CU1234 | Red |
| CU1234 | Yellow |
| FG9633 | Orange |
| FG9633 | Red |
| FG9633 | Pink |
| FG9633 | Green |
| TO1449 | White |
| TO1449 | Brown |
| TO1449 | Gray |
| TO1449 | Mint Green |
This is because this is going a continuous list and data needs to be presented this way because the other columns next to it has data that cannot be dynamic.
Thank you in advance.
