Discussions

Expand all | Collapse all

Filter records in a report for a parent table based on details of a child table

  • 1.  Filter records in a report for a parent table based on details of a child table

    Posted 06-28-2018 07:52
    I have a parent table (Deliveries) and a child table (Items), when a delivery arrives it is logged and Items are added to it dependant on what is in the delivery. Each of these items gets assigned to the user who ordered them (Items for different people can arrive in the same delivery) I want to have a report that shows all the Deliveries that contain items assigned to me (or any specific user)

    Cheers!


  • 2.  RE: Filter records in a report for a parent table based on details of a child table

    Posted 06-28-2018 09:44
    You can make a filter for Deliveries which have items for �me�, ie the current user.


    On the relationship make a Summary count of the # of items assigned to the current user.


    Then filter the Deliveries reports by


    [# of Deliveries for the Current User] > 0


  • 3.  RE: Filter records in a report for a parent table based on details of a child table

    Posted 06-28-2018 10:16
    This worked perfectly thanks!


  • 4.  RE: Filter records in a report for a parent table based on details of a child table

    Top
    Contributor
    Posted 07-11-2018 02:33
    Is there any way to solve the original question when Items are assigned to multiple users? Specifically, that the field type in Items is "List - User" and not "User".


  • 5.  RE: Filter records in a report for a parent table based on details of a child table

    Posted 07-11-2018 12:12
    You would need to post a new question explaining your need.