Can't get second table data to show in report

[ljungers]

I have a Report that uses a master table and has been working ok. Now I need to add some data from a second table called locations.

The master table has a column named loc_code, and the locations table has a primary key named loc_code. I checked and the relationship of the two tables and it looks to be fine.

Now I need to show the loc-name, loc_addr, etc from the locations table on this report. Not sure how this is done with Report in Access. How do I use the loc_id in the master table to match to loc_id in the locations table and use column data on this Report.

When creating the text box on the report, do I use the expression builder in the control source of the properties for each column that I want to place on the report or is there another way to accomplish this.

Thanks for any help and are there any examples someone could point me to.

[NeoPa]

You need to create a query where the two tables are linked and use that query as the source of your report.
If you need precise help with this you will need to post the MetaData for your tables - at least the relevant parts.
EG.
Table Name=Master

Field; Type; IndexInfo
StudentID; AutoNumber; PK
Family; String; FK
Name; String
University; String; FK
Mark; Numeric
LastAttendance; Date/Time