LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Filter on table lookup

    Employee
    Posted 11-28-2018 09:06

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: 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


  • 2.  RE: Filter on table lookup

    Employee
    Posted 11-28-2018 09:35

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: 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.
    Attachments:
    Feature Matching.brg