Display Different Table Fields Based on Selection of Drop Down Menu
I am trying to build a layout for a database of items. The items will have some common fields but some required fields will depend on the "category" of the item. My plan was to make an individual table for all the different "categories" which will all have different input fields.
I want to have a drop down menu with the categories and once the user selects the correct category, the input fields that are specific to that item's category will be displayed.
Can anyone give me any suggestions as to how I might go about accomplishing this?
Thanks in advance!