Check if a value is in a list of records

I have two tables in a relationship and need to check if the value in a field in the entered in the parent table exists in a column in the child table.  The use case, the parent table contains order ...