-
Filter on table lookup
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules