Is there a way to only select records where all child records of a related table equal a specific value.

Example: I have two tables incident and tasks. Each incident may have many tasks. incident is related to task by incident.recid to task.parent_recid.

I want to select all records where incident.status = active and where all child records where tasks.status = completed.

When i use the select expert i am getting results where one of the tasks is completed but all are not. I only want to display active incidents where all tasks have been completed.

Does anyone have any ideas?