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.