Values in a list based on a calculation.
Here's the background: I have a value list with a list of names for various jobs. This list is generated from the Name field in the Jobs table, and is used by almost every other table I've got to link the various records to the job they're about (hours, purchase orders, various forms). The Jobs table also has a Status field to denote whether the job is active or complete.
What I'm trying to do is set the value list to only contain Names from records where the Status field reads as "Active".
Any ideas on how I would go about this?