8 Replies Latest reply on Aug 1, 2017 2:40 PM by marthazink

    Conditional/Dynamic Value List based on a separate Field in record?

    ezeitgeist

      I swear I saw this in a demo but now cannot find the demo.

       

      What I am trying to do:

       

      I have a Test Table, Test Type Table, and Test Question Table.

       

      Test Table includes:

      Test_ID (serial)

      TestType_ID

      TestName

       

      Test Type Table:

      TestType_ID (serial)

      TestType

       

      Test Question Table:

      Question_ID (serial)

      Test_ID

      Section_Type

       

      Each TEST TYPE has DIFFERENT Section Names. I want to create a dynamic Value List for the Test Question Table "Section_Type" field that gives me ONLY the Section Names associated with the specific TestType of the Test_ID associated (to use in a drop-down to fill the field).

       

      How do I do this?