I have 3 columns
Material Type Name Availability
Fruits Apple Y/N
Fruits Mango Y/N
Vegetable Onion Y/N
Vegetable Chilli Y/N
Material type should be a dropdown.If i click Fruits i want all fruits to be listed row wise and mark them as Y/N against them.
Update: something in this format is needed.
A date with a drop-down and tick box setup.
Drop-down should call itโs related values.
Please guide me
For Material Type you should use an Enum column type in case the list is fixed. If the list may change in the future, then itโs better to store the Material Type names into another table, and link them.
Also:
I have further added a screenshoot can you please have alook at it
I have further added a screenshoot can you please have alook at it
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |