AnsweredAssumed Answered

Values in a list based on a calculation.

Question asked by RobertStephens on Mar 21, 2012
Latest reply on Mar 21, 2012 by philmodjunk


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?