I have two survey questions that reference the same list_name values . I wanted to know if it was possible to exclude the question #1 answer from the list appearing for selection for question #2, so that the same value cannot be accidentally entered twice (select_multiple [list_name] will not work for my purposes). The answer to question #1 will change, so I need my list for question #2 to be variable. Both questions are currently set to "select_one".
So if my questions were:
What is your favorite ice cream flavor? Chocolate
Do you have a second favorite? Yes
What is your second favorite ice cream flavor? Strawberry (cannot choose chocolate again)
Is this possible or is there a better way to do this? (Note: This has to be appended to an existing geodatabase, so it's necessary that the questions/answers remain separate and match the existing schema/field names.)