Value List based on date-field
I have a PERSONS-table and a related WORKSHOP-table (with 2 fields: workshop_name and workshop_date).
On the PERSON-table i have a portal. In this portal want to create a value list-field that includes all the workshop_name-fields that have a workshop_date that is higher than the current date.
Is this possible? How to do so?