Multiple Selections in a field

[simonb2013]

Hello

I have a field/column with a zillion values.

I need users to be able to select multiple different values from this column.

For example, if I have baskets of fruit, they want to find baskets that contain both Apples AND bananas.

SO in the 'Fruit Type' listbox, they will need to select both 'Apples' & 'Bananas'.

I know that there is a solution whereby users can use CTRL + Click to select multiple items, but ..

... given the large size of my list, this would become unworkable.

Users would end up selecting 1 item, scrolling pages and pages down the list to get the next.

What I'm ideally seeking, is a way to add selected items to a separate list, and use that list as a filter for my dataset.

Unfortunately I have no idea how to implement that.

Can anyone give me a pointer or two on how to get started ?

many thanks for any enlightenment !!

[Luis_Cortizo]

Would it be an option to create the listbox with the LED Checkboxes selection style (under presentation).

I don't really like its appearence, but its behaviour is that any new selection on the listbox is added to the actual selection.

Your users could click on Apples, then scroll down and click on Bananas (and the current selection would be Apples And Bananas), scroll down, Oranges (Apples, Bananas and Oranges) and so on...

Hope it helps.

Best regards.

[rustyfishbones]

Hi Simon,

You can create buttons and use Select in Field

something like

[rustyfishbones]

Hi Simon,

Please see the attached that may help you

Regards

Alan

[rustyfishbones]

Hi Simon,

You could also limit the list box by only allowing certain fruits to be part of the list box.

You would create a List Box Expression and add something like, you can add more Fruit types, below is an example

[sudeepkm]

I think you can use Search feature in List box. Users can select an item and then they can search for another item and then CTRL + Select the new item in this way they can select multiple items from a large list of values.