Skip to main content
Question

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

  • June 28, 2018
  • 0 replies
  • 31 views
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!
    This topic has been closed for replies.

    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
    • MaxAllen
    • Author
    • Registered
    • June 28, 2018
    This worked perfectly thanks!
    • ArchiveUser
    • Registered
    • July 11, 2018
    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".
    You would need to post a new question explaining your need.
    Terms & ConditionsAccessibility statement