Trying to connect tables to consolidate info on a report

OK so I have multiple tables... we call jobs "Opportunities" - these require a "Layout" and sometimes they result in a "Loose End". So each "Opportunity" can have multiple "Layouts" and "Loose Ends" ...