filtered value list and field validation

[raingirl]

I am trying to create a filtered value list of students who are boys, boarding and do not have a rooming assignment.

Since I cannot seem to create a filtered list with any calculated fields that cannot be indexed (ughh), I need to have more of a dynamic lookup field. The problem is when you assign a Student ID to a Bed (in the Bed Table), the Bed_ID does not automatically populate in the Student table. In order to show a filtered list of students who do not have a Bed_ID (student table), I need to be able to auto-enter this field when someone adds the student_ID to the corresponding bed. The field does not automatically look itself up because it is in a different table. Is there a more dynamic way of getting a lookup/text calculated field to populate?

Thanks!

[comment]

I have just now answered this here.

But see also this thread.