Results 1 to 2 of 2

Thread: Filter on table lookup

  1. #1

    Default 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

  2. #2
    Lavastorm Employee stonysmith's Avatar
    Join Date
    Nov 2006
    Location
    Grapevine Tx
    Posts
    799

    Default

    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.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •