Alternate state multiple select in listbox's

[Chernov]

i create simple data:

Load RecNo() as ID, * Inline
[ShopName
Shop-01
Shop-02
Shop-3
Shop-4
Shop5
Shop6];

create 2 alternate states: State1 and State2

for select one value from state1 to state2 and create trigger on select ShopName action : select in field ShopName, and value =ShopName this work fine.

But i want to select multiple shop's - how i can do this ?

[whiteline]

Hi.

May be like this:

=Concat({State1+State2} ShopName,' | ')

[Chernov]

not work

[whiteline · Accepted solution]

Ah, do you want to make selection for State2 relative to State1 ?

If so, you can do it directly without variable, using OnSelect trigger for ShopName field, see the screenshoot.

You have to use explicit state and add the braces like this ='(' & Concat({State1} ShopName, ' | ') &')'

Also you have to set the state for the action.

add:

to be completely sure you can also add the quotes:

='("' & Concat({State1} ShopName, '" | "') & '")'

[Chernov]

yeah! thanks