Forum Discussion

PhillipWisoff's avatar
PhillipWisoff
Qrew Trainee
7 years ago

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

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...
Relationships
reports and charts
KingslySamuel's avatar
KingslySamuel
Qrew Cadet
7 years ago
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.
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
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.  Is that all you are looking for?    or are you looking to have the children items be visible on a report of Parent Lots.