Listbox help with Expression in Field

[tom906123]

Hello,

I am trying to filter a data set by relationship: Related or Unrelated.

My data set does not have this parameter included however the logic to determine this is if "rel" is located in the Name.

I am trying to write an expression in a list box to have this behave accordingly.

If Related is selected, then I would like to see that logic applied to the other selections and vice versa if Unrelated is selected.

Any help would be greatly appreciated!

[vishsaggi]

What is the field name for your listbox and what are the values this lisbox holds now? Are there only two values like Related and Unrelated or you want to search a string in this field for Rel and Unrel values? Can you elaborate with an eg so that we can help you quickly. ?

[tom906123]

Field Name is clientname

The table for this field looks something like this

clientname|

abcdrel

abcrel123

xyz321

I would like two values in the List Box: Related and Unrelated

If I select Related,  I would like to results for all client names with "rel" in it.

Thanks so much the help!

[vishsaggi · Accepted solution]

write this in your listbox in general tab Field - Expression

= IF(WildMatch(clientname, '*rel*')>0, 'Related', 'Unrelated')

[tom906123]

Many thanks!! Worked like a charm