Query 3 tables

[SamMaynard]

Database info...
I have one table called tblStudents with a unique identifyer feild called StudentID.

Another table called tblRoomsNumbers with a unique identifyer feild called RoomNumber.

Then I have a third table called tblRoomMates that has two feilds named StudentID and RoomNumber (both are a lookup data type). The idea is to join have the RoomNumber feild joined to one or more StudentID. This works well. No problems

Here is the problem...
When I query using the tblStudents and tblRoomMates tables and a student hasn't been assigned to a room yet in the tblRoomMates table, that student will not come up in the query at all. In other words I am querying lots of info from the table tblStudents like phone numbers, age ect. but if they haven't been assigned a room number from the table tblRoomMates none of their data comes up.

Question...Any ideas how to get the students info like phone number, age, ect. to come up even when the student hasn't been assigned a room number?

Also...
Any idea how to generate a query that will list the students who haven't been assigned a room?

 

[jobb]

1.
in your query, double click on the join line between the two StudentID fields, this should bring up the "Join Properties" for your query. Then select the option to "Include All Records from 'tblStudents'...
Thus, all students, even those who aren't in your Roommates table, should show in your query.

2.
To show only those students w/out a room... do what I suggested above, only just put "Is Null" as a criterion for [studentID] in your roommates table

I hope that was clear..

 

[SamMaynard]

Thanks a ton. I really appreciate it.