Query to check for same cell value access table

[froseph]

I've created a database with entries corresponding to different participants in a tasting experiment. All the entries are stored in a single table. The participants are each members of a family, with participants of a family given a family number (increments with family) (see image link below).

imgur.com/yM1vO59

I want to be able to check that for either 'Mother' or 'Father' of 'Child1','Child2', etc. within the same family, the location within the sweet, sour, bitter column is the same.

(I'm asssuming five queries will have to be run, one for each of the flavours).

To reiterate, I want to check for example if 'Mother' and 'Child1' within 'Family Number' 3 taste 'Bitter' in the same place (Which they do - 'Middle').

Any help greatly appreciated - Thanks!

 

[GinaWhipp]

How do you determine which Family Group any given Participant is a member of? Sounds to me like more then one table is needed here...

 

[froseph]

Gina - By family group do you mean each separate family? Members of the same family have the same family number, e.g. the first Child2 and Mother are in family 1, etc.

 

[GinaWhipp]

Yep, and I just noticed there was an image link! :banghead: WHich answers my question...

In your present set up, the only thing that comes to mind is a DLookup on the Form to check which Family Group the Entity belongs to.