How do I combine several fields into one field arranging the data alphabetically?
Posted on 2005-04-26
Good morning everyone. I have created a form in Lotus Domino Designer that has several fields I would like to combine into one field during Opened for Reading Mode. In Edit Mode the fields look like this:
Field 1 = Clear Beans
Field 2 = Blue Beans
Field 3 = Green Beans
Field 4 = Select another brand...
Field 5 = Select another brand...
As you can see the user can select however many brands are carried at a particular store. I would like to combine the data into one field in alphabetical order when the form is in Opned for Reading Mode, excluding any "Select another brand..." choices.
Field 6 = Blue Beans, Clear Beans, Green Beans
How can I do this?