Find a selected value in a list

[Anonymous]

This is driving me crazy. I know it's straight forward, but my mind is blank.

I have 2 unrelated tables. One Fruit the other Veg.

When i select a fruit i want to know if it appears in the Veg list and return is in a textbox.

I have attached a qvw to display what i mean.

I thought it was =IF(Match(GetFieldSelections(Fruit),Veg)>0,'Yes this appears in the Veg list', 'No this does not appear')

[swuehl · Accepted solution]

evason75,

Veg is not a list of strings you can use in the match() function. You can work out a solution using concat to create a list of values from your field or try:

=IF(count({<Veg=Fruit >} Veg)>0,'Yes this appears in the Veg list', 'No this does not appear')