Want to find where 2 fields don't match

[Tearose]

I have two fields that contain largely the same information. I would like to generate a list of the entries that only occur in the first field but not the second. (Complicating matters, some of the entries may be in both fields, but not in the same entries- say entry 4236 in the first field, but entry 3578 in the second. I doubt that there's a way to deal with that aspect while in FMP5.5) If this isn't possible, I have a way to find when the entries in both fields match; is there a way using that to find when they don't match? Can I then import just the resulting list of those two fields to Excel?

 

[JeanW]

Without going too deep, I think you have to look in the direction of a multi key relationship to isolate the matching fields.

Have to think a bit further on this.
I have the feeling I used a technique way back, problem is to find that file again....

 

[Livia8]

This might help, hopefully: if you were to copy the list to excel, you could then go to Data, filter, advanced filter, then select the list range and click the box that says unique records only.