AnsweredAssumed Answered

How can I duplicate only certain data from a table for a value list?

Question asked by user447 on Dec 13, 2015
Latest reply on Dec 13, 2015 by Mike_Mitchell

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!