display a field value from one table to report based on criteria

[Guest]

Hi, Acually I have a table called location and it has two fields, ID and Location. I have another table called ProgramInfo and having many fields and as a foreign key I have LocationId in that table

Now I am trying to build a report in Access that instead of LocationId , somehow I can get Location from location table. Can some body help me out

Thanks in advance
aarti

 

[Marshall Barton]

Hi, Acually I have a table called location and it has two fields, ID and Location. I have another table called ProgramInfo and having many fields and as a foreign key I have LocationId in that table.

Now I am trying to build a report in Access that instead of LocationId , somehow I can get Location from location table. Can some body help me out.

Use a query as the report's record source. When you create
the query, add both tables and make sure the connecting line
is between the LocationID and ID fields. Then you can add
the Location field to the query's field list and use it in
your report.