I'm working with Lotus notes (7) designer to create a form on which one of the fields is to be a dialog list. I would like to populate the list using 'use formula for choices' and then from the formula access a lotus script variable declared in the globals of the form. Does anyone know if this is possible? Or maybe I should be populating the list from Lotus Script?
To give a bit an example two lists defined in Lotus Script
fruits -> apple, pear, banana
vegetables -> carrot, courgette
The dialog list should show all the items of the two lists, then depending on the item chosen, if it is a fruit then one action will be taken, if it is a vegetable then another.
Thanks for any help