Record Selection criteria problem

[pbateman]

I want to limit the rows returned from a table (Parent) by the content of a Child table's field or if the Child does not contain a row linked to the Parent table. The Child is joined to the primary key on the Parent table. I am using version 8.5.

 

[lupins46]

Make sure your join is set as an Inner Join.

 

[pbateman]

I've sorted it now thank you.