AnsweredAssumed Answered

How do I base a value list on a field?

Question asked by xyrus on Jun 30, 2018
Latest reply on Jun 30, 2018 by xyrus

I am trying to create a value list, based on a value of a field, that can be used in a related table. Example: I have three tables; students, devices and an index table related to both. The students table has a field showing status (enrolled, withdrawn, graduated, inactive). In the devices table, I have a portal showing the index table, where I can use a field to assign a student to a device in that relationship. I use a conditional value list to show all students but I only want to show all enrolled students, not other students as they would never be assigned a device unless otherwise enrolled.


Is there a way to create a value list based on the value of a field to only show enrolled students?