i have a separate form for tool and item inventory, which can be assigned to trucks through a look-up field that allows you to select the truck number.

i would like to have the items for the selected truck in the truck report 'view record' to show the items assigned to that truck. i though about putting the tool and item form in the truck form as a subform but that only lets me input new information.

 is there a way to do this ?