Finding records with discrepant values in three fields
I'd appreciate help for a beginner (FMPro 10 on Mac OS X Leopard)
This is a project where records are coded (by humans!) according to the data in multiple other fields. Observer 1 has summarised the characteristics of each record (as he sees them) in three additional radio button fields on the record (property 1, property 2, property 3). To check inter-rater reliability Observers 2 and 3 have each replicated the exercise, using different layouts where they can't see other observers' scorings.
I now want to pull out the records where any of these ratings (for properties 1, 2 and 3) differ between observers, i.e.
find all records then
omit records where (property 1 rated by observer 1 = property 1 rated by observer 2 = property 1 rated by observer 3)
AND (property 2 rated by observer 1 = property 2 rated by observer 2 = property 2 rated by observer 3)
AND (property 3 rated by observer 3 = property 3 rated by observer 2 = property 3 rated by observer 3)
so that we can look at where our ratings have differed.
I'm getting in a bit of a tangle with this and would appreciate help.