Dialog List with @dblookup formual and aliases

HCL Domino Domino Forum
1

I have inherited support of a database that has a dialog list field that gets its choices with a @dblookup formula that pulls the choices from a separate form. The choices are stored in a single field on this form in the following format.

Choice 1 | 1

Choice 2 | 2

Choice 3 | 3

The problem is choices need to sometimes be removed from this list, so on existing documents that have the removed choice in the dialog list field now display the alias because choice has been removed and thus can not resolve. I need to find a way to remove a choice from the list and still have the non-alias value displayed. i.e. remove Choice 2 from the list and on existing documents that have Choice 2 selected display Choice 2 and not the alias 2.

Thank you in advance for any help you can provide with this.

2

Subject: Dialog List with @dblookup formual and aliases

That’s not an easy question to deal with. If the alias is no longer available somewhere, there’s no way of displaying it. You could try to store a list of previous pairs in a separate field. But what’s going to happen, if the old alias is used for something completely different later on? Make sure that you have a concept for that, before approaching a solution for the display problem.