filtering child record in mother table

[knowledge76]

HI friends,

I want to ask you a question regarding my current problem.

I have a table with mother and child records.

The child records in the subsheet have a column Engine. Now my question,
is it possible in Ms access to get only those mother records where in the child record the Engine is defined as Diesel.

 

[Rabbie]

Provided there is a relationship between the two tables just create a query selecting all the records with the criteria on the Engine Column set to "Engine"