Multi value selection, wide window and retain values

Hi,

How can I provide a list of options for a user to choose multiple values where the window width is fairly large and the selected options are retained?

I have tried the following

dialog list with formula using DBColumn - window not wide enough

dialog list with view - values not retained

@PickList - values not retained

Fixed width listbox with DbColumn - Customer does not like the look of this

The user needs to be able to alter the selection easily

Changes can be deletions or additions

The selection options consist of two keys concatenated together i.e. Workplace and Area

I have thought about allow the user to select Workplace first and then Area but there are times when multiple Workplaces are required

Any help much appreciated

TIA

Subject: Multi value selection, wide window and retain values

@Picklist - why aren’t the values being retained? What is retained when you use @Picklist? When I need lots of real estate, this is usually where I go.

Ditto on the Dialog list; works fine for me if I use view dialog for choice (and I get whatever view layout is defined so real estate shouldn’t be an issue).

Have you set the field to be multi-value?

Subject: RE: Multi value selection, wide window and retain values

What I mean by not being retained is that when the user next goes to the selection their choices previously selected are not selected - hence they have to select them again

From the Help

@PickList doesn’t offer a NoCache option like @DbColumn and @DbLookup because lookup results are never stored. Each time @PickList is executed, a new lookup is performed.

Dialog List with a view performs the same way

Thanks for your input

Subject: RE: Multi value selection, wide window and retain values

Still not clear.

Are we talking about fields that are defined as dialog lists, or buttons that present @PickList and then set a field, or something else?

If you’re setting a field value somewhere and you can see the value gets set until you move to another field (or refresh the form), then I’d look at the field translation formula - you could have code there that’s killing whatever you set.

Doug