1 Reply Latest reply on Nov 25, 2014 10:11 PM by philmodjunk

    Summarizing Data based on multiple related tables (relationship filtering)

    Vinny

      Title

      Summarizing Data based on multiple related tables (relationship filtering)

      Post

      Hello,

      I have a simple database structure as follows

      Invoice Table:

      Invoice_ID

      Invoice_Date

      InvoiceLine Table:

      InvoiceLine_ID

      InvoiceLine_Amount

      fk_Invoice_ID

      fk_InvoiceLine_Type_ID

      InvoiceLineType Table:

      Type_ID

      Type_Name

       

      I would like to know how to:

      Develop a report or layout that shows:

      Type_Name    Sum(InvoiceLine_Amount)

      BUT, I want to filter it by a date supplied by the user in the layout.

      I can easily show the Sum(InvoiceLine_Amount) totaled by Type_Name; however, getting the date filter involved in this relationship is difficult given the date is in a table related to InvoiceLine.

      Can anyone explain how to do this?

      Screenshot.png