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?