Question about LOOK UP

[hediondo19]

Hello friends
I have experienced a problem when it comes to a look up feature i
Access. I am making a database for my schools blood drive and I nee
my Database to have the capabilities to look up the Room number o
where the student is at in a specific period. I have the table wit
the teachers and their room numbers and I have a different table wit
Student names and period they want to give blood and their teacher fro
that period. all i need it to do is look up the room number from th
other table. can anyone help me

 

[dandgard]

You should have some sort of teacher ID in both tables. And I a
assuming that no teacher id can exist unless it also resides in th
teachers table.

Create a new query from both tables making a join at the teacher i
field for both tables and then add whatever information you want to th
qbe grid.

use this select query to fill your form or report

 

[John Vinson]

Hello friends
I have experienced a problem when it comes to a look up feature in
Access. I am making a database for my schools blood drive and I need
my Database to have the capabilities to look up the Room number of
where the student is at in a specific period. I have the table with
the teachers and their room numbers and I have a different table with
Student names and period they want to give blood and their teacher from
that period. all i need it to do is look up the room number from the
other table. can anyone help me?

You will need to create a Query joining the tables. Since you don't
say which fields are available to link the tables, I don't know quite
what to suggest - is there some field in the Students table indicating
who their teacher is, or (better) a third table listing the StudentID,
the period, and the room number or class ID?