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.