Skip to main content
Question

Display all the matching records in multiple child tables from a parent record

  • March 6, 2019
  • 0 replies
  • 58 views
I am working on an inventory system and have a parent table ("Lots") with two child tables ("Standard Items" and "Unique Items").  I would like to create a report (or page) where I can display all the items associated with a particular lot record.  Any ideas will be greatly appreciated.
    This topic has been closed for replies.

    Is there any relationship between the standard and unique items? If yes, you can use "look up" option in relationship to pull all data into the the last table (Unique Items) and have a report created the way you wanted in that table to show all info related to a lot.
    • PhillipWisoff
    • Author
    • Registered
    • March 7, 2019
    Thanks for the suggestions.  I am farely new to Quickbase.  So, this may be a easy question.  The embedded report links you suggest.  I am reading this as these links being displayed as buttons that I would click on when I view the Lots report.  Clicking the button would take me to the report with the list of items related to the specific lot record.  So I would have two buttons, one for each report link.

    That's ok, but what would be really nice is to click one button from the identified lot and then have all the items from both child tables be listed in one report (or a page with the reports from both item tables).  Or display a form where I select a specific lot and then all the associated items (from both tables) would display.

    Just not sure how to do this.  Thanks again.
    No no no..it�s way easier than that.


    Just put the report link fields on the form and set the form properties for those two Report Link fields to display the child records in the form. No buttons to push. You can control the report columns and sort by making an unfiltered report to use to display the records.


    The report link fields get auto created when you created the relationships.
    Terms & ConditionsAccessibility statement