AnsweredAssumed Answered

How do I limit choices on a Pop-up list?

Question asked by g4guitar on Nov 14, 2015
Latest reply on Nov 14, 2015 by g4guitar

I have a layout called ‘Class’. On the layout is a field called ‘Student’ which has a pop-up menu linked to a table called ‘Contacts’. This allows me to select the student’s directly name from the Contacts table. What I want is for the Pop-up menu to only include 'Booked' and 'Current' students which is based on another field in the Contacts table called ‘Status’. Status has several choices apart from 'Booked' and 'Current' such as 'Inquiry' and 'Past'.

How would I achieve this? Thank you.