Relationship Problems

[KashLeeC]

In my database, I have a master table like so:

Name, School, Math, Science, History

Name is the contestant name, school is his school, and the last three are check boxes telling if he competes in that specific subject.


I then have three other tables, scores for each one that have:

Name, School, Math/Science/History

The score on that subject is placed in the last column.


My problem: I want to create some sort of query (not sure the best type) that has:

The name of each contestant
The school the person attends
A column for each subject with the score they got, blank if they didn't take it


Any suggestions? I'm not sure how to set up the relationships to do this. Thank you!

[mbarron]

Use an outer join from the master table to each of the three class tables. Use the Name and School field from the master table and the score column from each of the three class tables.

See attached for a demonstration.

[KashLeeC]

Thank you so much for your reply! That is exactly what I am looking for!