Queries from multiple tables with same Column name

[Colleen]

I have a Parent table called Participants with an auto numbered Primary Key and fields with details about each participant.
I have 4 other tables dedicated to specific types of fluid donations each with a Field called Participants that is filled the the corresponding autonumber from the parent table.

I want to be able to build a query that shows me the participant and then all the types of donations they are a part of.

I have not figured out how.

My relationships are from the Parent Participant Primary Key to the Participant field in each table.

*
|
0 --*
|
*


I am not a programmer and need to use the Access interface.

Thank you.

 

[jdraw]

This free video(and follow on) should help with concepts so you can adapt his example to your needs.