I have a "service_casemis" valuelist, based on records in a choice_list table. They are linked to the other tables by UID keys, established when a user selects a service from a drop-down menu.
Some of the values are no longer used, because the codes have been retired. However, old records may still have them assigned.
I can find the current ones in choice_list by, say, today's date. I could create a dataset of these records to populate a static valuelist. So these could appear in the drop-down for the user to select.
But how, then, could I also show the legacy values for records that have these values assigned? The user doesn't need to *select* the legacy values, but should be able to see and remove them.
Thank you,
Don