AnsweredAssumed Answered

Conditional Value List based on related table field?

Question asked by ezeitgeist on Oct 4, 2017
Latest reply on Oct 4, 2017 by philmodjunk

SETUP:

I have a TestResponses Table that is related to TestQuestions Table via the Questions_ID (Serial field of TestQuestions Table).

TestResponses::Response options vary depending on the TestQuestions::Answer

(ie. If TestQuestions::Answer is "B" then the radio button options for TestResponses::Response need to be A, B, C, D.

If TestQuestions::Answer is "F" then the radio button options for TestResponses::Response need to be E, F, G, H)

 

GOAL:

Depending on the TestQuestions::Answer value, for the Value list for TestResponses::Response in the layout to show the appropriate button options.

Outcomes