G
Guest
I have two tables, students & homeless students. They are joined with a left
outer join based on student ID number because not all students are homeless.
The student table has the student ID number, first name, last name, address
etc. The second table has student ID number and details about their homeless
situation. I want to develop a query where we can enter records into the
homeless table. I want to use the student ID number in the query from the
homeless table and have the query pull the first name, last name and address
from the student table. When I try this and enter the student ID of a
student who is already in the student table, the last name etc. doesn't fill
in until I close the query and re-open it. Any helpful hints. (I do have
many other tables in the database (schools, principals etc) but I don't think
any of them have to be part of this query.
Thank You
outer join based on student ID number because not all students are homeless.
The student table has the student ID number, first name, last name, address
etc. The second table has student ID number and details about their homeless
situation. I want to develop a query where we can enter records into the
homeless table. I want to use the student ID number in the query from the
homeless table and have the query pull the first name, last name and address
from the student table. When I try this and enter the student ID of a
student who is already in the student table, the last name etc. doesn't fill
in until I close the query and re-open it. Any helpful hints. (I do have
many other tables in the database (schools, principals etc) but I don't think
any of them have to be part of this query.
Thank You