Filtered valuelist
Posted: Wed May 09, 2012 11:58 pm
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
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