AnsweredAssumed Answered

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

Question asked by ezeitgeist on Aug 1, 2017
Latest reply on Aug 1, 2017 by marthazink

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?

Outcomes