Trouble pulling Name instead of associated ID number

[tjones]

I have three tables the tblStudentInfo (holding the persons main data), the tblEducation (holding the students education records) and the refInstution (holding all university's and college information)

I am pulling PersonID, name, etc from the tblStudentInfo, education records from tblEducation.

the problem is that in the query it displays the institution ID instead of the Institution name. How do i get the query/rpt to show the name instead of the ID?

On the form Institution this is pulled from the refInstitution table and the ID InstName etc is a combo box 0; 1.0; etc so the display on the form shows the name of the university instead of the ID number.

 

[CJ_London]

If you want the institution name in your query you need to link to the necessary table (refInstution?) to pull it through

 

[tjones]

I tried pulling the refInstitution table into the query but it just makes the query not display any information.

Not sure what I am doing wrong. I have included a graphic of the query.

 

[CJ_London]

Some basic thngs to check

Is your institution table populated
Are you linked to the correct field
Is the data in your tblIPSEducaton Instituton field consistant with the one in refInstitutions

It looks to me like you should be linking to InstitutionID