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

  • 1
  • 1
  • Question
  • Updated 11 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

  • 322 Points 250 badge 2x thumb

Posted 12 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 69,924 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

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

Adam Dowell

  • 110 Points 100 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

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