I have licensees (table 1) that take continuing education (table 2).
I show the education classes taken by a licensee in a portal. We choose from a value list of all continuing education classes from
the classes table.
when classes are added to the CE Classes table, they have a beginning date and an expiration date.
I need this drop down value list of classes to only show classes that are not yet expired.
Do I need to create a duplicate of the classes table and somehow filter it? Just not sure how to only pull current classes for the value list.
Thanks for any guidance!