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

  • 1
  • 1
  • Question
  • Updated 4 months ago
  • Answered
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!
Photo of Max Allen

Max Allen

  • 302 Points 250 badge 2x thumb

Posted 5 months ago

  • 1
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,326 Points 50k badge 2x thumb
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
(Edited)
Photo of Max Allen

Max Allen

  • 302 Points 250 badge 2x thumb
This worked perfectly thanks!
Photo of Adam Dowell

Adam Dowell

  • 90 Points 75 badge 2x thumb
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".
(Edited)
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,326 Points 50k badge 2x thumb
You would need to post a new question explaining your need.