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.
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)