Descriptions not appearing on report

[upsman]

I have 3 tables - 1 contains a classid (as the key) and a class description, the 2nd contains a teacherid (as the key) and a teacher name, the 3rd contains a studentid (as the key) and the classid(s) of the classes they attend and the teacherid(s) of those classes.

When I print a report using the 3rd table, all I get are the id fields because that's what's stored in the table. What I want is the class description and teacher name that match the respective classid and teacherid. How do I get Access to "read" the first two tables using the classid and teacherid from the 3rd table as the keys and return the class description and teacher name to print on the report? I also need to use the studentid to read a 4th table to retrieve the student name to print on the report.

I'm new to Access so I don't know the syntax to use to get it to read a file(table) based on a key and return a different field from that table.

Thanks in advance,
Rod

 

[statsman]

Create a query that contains all 3 tables.
In the query, use the fields from the tables that contain the data you want.
Run the report from the query instead of the table.