Looking up members of list in another list

[TheGrinch]

Hello All,

I have two separate lists of data, List A and List B. I want a new field that tells me (yes or no) whether or not each member of B appears in A.

Note: this is easy in excel: simply copy the following formula along side list B: =countif('$list$A','memberofB').

The lists are too big for excel. Any suggestion or comments on how to achieve this in filemaker would be very much appreciated.

CHEERS

[Søren Dyhr]

I think a template to show how it could be done, serves this case better than explaining!

Nytarkiv.zip