relating one table to three fields in another table

B

bumpmobile

I have a table tblStaffInfo. I also have a table tblStudentInfo. In the
latter table I have fields for PrimaryHouseParentID, AcademicAdvisorID, and
TherapistID. I would like to relate all three of those fields to the
StaffInfo table and create a query that would pull LastName, FirstName,
Phone#, etc. for the three different staff and put it on a form. I just
can't seem to wrap my brain around how to make it work. Any suggestions
would be appreciated.

Adam Milligan
 
D

Duane Hookom

Add the table tblStaffInfo into the query three times. Join each copy of
tblStaffInfo to a different field in tblStudentInfo.

Some programmers might suggest you normalize tblStudentInfo to remove the
repeating links to staff.
 
Top