Forum Discussion

MaxAllen's avatar
MaxAllen
Qrew Cadet
7 years ago

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

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!
reports and charts
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    7 years ago
    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".