This video demonstrates how to use table data to join information between tables. Then using the primary and foreign keys, we use that dataset to pull individual pieces of information from each of the forms.
Video
Watch the video Join Data to Create the Report.