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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Aarti said:
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.
Click to expand...


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.
 
Back
Top