Dynamic Value list (unassigned only)

[hlabonte]

Not sure if this is the correct board, but... (FMP7)

I'm creating a small database consisting of two files. Students and DormRooms. The DormRooms is a finite list of available dorm rooms for bed assignments. The Students file contains a field for "dorm_assignment".

In the students file, I have a field used to assign a room (value list from DormRooms). How do I make that value list dynamic, and allow only the unassigned rooms to display?

Curious to read thoughts on this.

Thanks in advance.

[comment]

You could try something like this (attached). Note that there is a refresh issue, so the field is popped by a script.

Dorms.fp7.zip

[hlabonte]

Thank you, that'll do it!