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.
  • PhillipWisoff's avatar
    PhillipWisoff
    Qrew Trainee
    7 years ago
    Unfortunately, there is no relationship between the two item tables.  Thanks for the thought though.
  • 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.
  • KingslySamuel's avatar
    KingslySamuel
    Qrew Cadet
    7 years ago
    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)