Creating a Form Query two show linked information

[ChrisKipper]

I have three tables, STAFF, MODULE and STAFF_MODULE.

Staff contains information about members of staff
Module contains information about the modules such as name and description
Staff_Module contains a staff ID and a Module ID that is linked from ther own table as more than one member of staff can teach more than one module and same with the other way around.

I would like a query that when I type in a staff members name on an access form, it would show the modules that the teach.

 

[ChrisKipper]

Creating a Form Query to* show linked information. Wow.