Showing only records that meet a condition in value lists
Is there a way to only show a field from a record in a value list if a condition is met?
I have a stock table where each item has a status field. I would like to base a value list only on records where the status is set to available and omit those whose status is set to unavailable.
Thanks in advance