4 Replies Latest reply on Jun 9, 2014 6:15 AM by philmodjunk

    Display Different Table Fields Based on Selection of Drop Down Menu

    RoyBanks-Bywater

      Title

      Display Different Table Fields Based on Selection of Drop Down Menu

      Post

           Hi,

           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!

           -Roy