Form1 has a look-up to a Team

Team is connected to Teammembers

How do I get a report that connects Form1 with all of the Teammembers?

ie, if a record in Form1 is connected to TeamA, and TeamA has 5 teammembers, my report (unfiltered) would have 5 rows (ie, 1 row for each teammember)

in MS-SQL, the view would be:

select T1.*

,TM.*

from

Form1 as T1

inner join Team as T2 on T1.teamid = T2.teamid

inner join Teammembers as TM on TM.teamID = T2.teamid