Servoy Forum

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

Why not use the 'fallback' valuelist option? For some things it doesn't work so for instance in find mode the valuelist will always revert back to the fallback valuelist which sometimes isn't wanted. But it sounds like in this case it would work. This might be especially true if I read your post correctly that users will actually be updating these legacy values.

I just tried it, and it seems to work very well.

Thanks John!
- Don

BTW, is it possible to have a fallback valuelist of a fallback valuelist?

Don