remove multiple items from field

[userid128223]

I have table like below.

Student

John

Cline

Viennesa

Ivan

Mike

I want to create a button to exclude John & Mike from selection once Button is pressed. How can i achieve this.

Thanks

[vishsaggi]

What should happen when you clear selections? Does all the names should show? Where these values should be displayed in a Listbox? Or in a chart? If list box then go to List box properties then check the box Hide Excluded.

Then create a button with action as Select in Field then give Student as field and string as

= '(' & Concat({< Student -= {'John', 'Mike'} >}Student, '|') & ')'

[userid128223]

I don't want to just hide the name but instead want to remove them from selection for all the charts & list box.

i have button that selects multiple value for one field. In the same button i wanted to now exclude multiple value for 1 field.

[vishsaggi]

Try to use that Set statement in your button. Can you share the expression you are using for the button you have?

{< Student -= {'John', 'Mike'} >}

Can you share a sample you are working on?

[userid128223]

Attached is example. I have Button1 which selects Student Cline, Ivan  & Mike.

Below is what i want to do.

1) Exclude Teacher = Allen

2) Select Mike, Ivan & Cline

Both using same button.

Final Result: Cline & Ivan will be highlighted. As Mike has Allen as teacher.

[vishsaggi]

Allen has a student Ivan so when teacher Allen is excluded his student Ivan is excluded so only Mike and Cline will be selected. Is it not. ?

[userid128223]

Yes

[vishsaggi]

use this as your search string and see.

= '(' & Concat({< Student = {'Cline', 'Mike', 'Ivan'}> - <Teacher = {'Allen'}>} Student, '|') & ')'

[userid128223]

when you select Teacher Allen and select excluded it shows up in your Current selection box. How do you see the same results when you are doing via button

[vishsaggi]

Did not get you. Can you send me a screen shot of what you are expecting?