Filter on table lookup

[mw9286]

I run a query to get a list of customers and the features on their account. I have a table based upon a parent/child relationship, if the customer has the parent feature the child feature should be free. Below is a sample output from the query and table.

How do I filter out the child features if the BAN has the parent feature?

Query results
BAN FEATURE
123456789 U300
123456789 TMC
123456789 SHO
987654321 U400
987654321 FLIX
987654321 HBO

Excel Table

ID ParentFeatureCode ChildFeatureCode
57 U300 FLIX
58 U300 SHO
63 U300 TMC
69 U400 FLIX
70 U400 SHO
76 U400 HBO
230 U400 TMC

[stonysmith]

Take a look at the attached sample. I'm not sure what you are asking for by 'should be free', but this should give you a starting point.