"Filtered" Value Lists
This is driving me batty.
The relationship here is simply Shops to Job via a fixed and a calculated value. The Job record always carries the value "1" in it's key field and the Shops records carry "1" if their status is "Active" and zero if not.
The portal works perfectly but I can't get a popup menu to exclude the zero key record. In this case Shop 4 using the same relationship.