base your value list on class table that has calculated constants of "Booked" and "Current", make the appropriate relationships to the Contacts table status field and make sure your value list setup look across the relationship.
Their are other ways to do this.
In Contacts, create an auto-enter field called "BookedOrCurrent". Use a formula such as:
Status = "Booked" or Status = "Current" ; Student ;
Base your value list for that location on the values in that field. If a student isn't booked or current, the "BookedOrCurrent" field will be blank. The list will automatically filter itself. Make sure to uncheck the box "Do not replace existing value of field". For existing data, copy that formula and use Replace Field Contents to populate it for all contacts.
Brilliant. Worked perfectly. Thank you so much.
Thank you very much. That was very helpful.