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

Question

I am working on an inventory system and have a parent table ("Lots") with two child tables ("Standard Items" and "Unique Items").&nbsp; I would like to create a report (or page) where I can display all the items associated with a particular lot record.&nbsp; Any ideas will be greatly appreciated.

kingslysamuel · Answer

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)&nbsp;and have a report created the way you wanted in that table to show all info related to a lot.

phillipwisoff · Answer

Unfortunately, there is no relationship between the two item tables.&nbsp; Thanks for the thought though.

quickbasecoachd · Answer

Are you aware that on the Parent table for Lots, your form for viewing the lot record can include the two Report Link fields for showing the child record directly on the form.&nbsp; Is that all you are looking for?&nbsp; &nbsp; or are you looking to have the children items be visible on a report of Parent Lots.

kingslysamuel · Answer

It more sounds like a need for a report. But, yes the other option is to use the embedded report as a report link and have it displayed under a Lot's record (in Lot's form)

phillipwisoff · Answer

Thanks for the suggestions.&nbsp; I am farely new to Quickbase.&nbsp; So, this may be a easy question.&nbsp; The embedded report links you suggest.&nbsp; I am reading this as these links being displayed as buttons that I would click on when I view the Lots report.&nbsp; Clicking the button would take me to the report with the list of items related to the specific lot record.&nbsp; 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).&nbsp; 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.&nbsp; Thanks again.

Forum Discussion

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

Related Content

Display Thumbnail Image

Using Grid Edit to Edit Multiple Records at Once

Edit Multiple Records at Once with Grid Edit

New Form Button display settings

Form rule modal display a link