Access Database - Entities Not Linking

[jammy1812]

Hi guys,
I'm making a database to show a school and it's members, etc and I'm trying to run queries (and sub queries) to show how staff are allocated.

However, when I run the queries I've made, they don't seem to be returning the expected results.

For instance, I want a query to show:

faculty id, faculty name, person id, person firstname and surname, subject id and subject name.

I expect the format in the following:
1, Science, 1, Henri Blanc, 1, Biology
1, Science, 2, John Green, 2, Chemistry
1, Science, 3, John Black, 3, Physics
2 Arts/performing arts, 4, Joe Grey, 1, Biology
2 Arts/performing arts, 4, Kevin White, Chemistry

But when I run the queries, I get a list of all the members of the database and they're allocated to each faculty and subject...

Can anyone help me so that my database shows the proper allocations?

[alansidman]

Your issue is that you have not developed any relationship between the Person table and the other two tables you are involving in the query. If there is not a relationship between the person table, then Access cannot determine what faculty they belong to nor what classes are taught.

Look at this link on relationships

http://www.deeptraining.com/litwin/d...aseDesign.aspx