primary key on report

[Walter]

How do I get the data to print in a report instead of the
primary key field? I used the wizard to create the
report. The report is based on a table which includes the
primary keys from several other tables. These are simple
tables with 2 fields;
tblFarms:
FarmID - primary key (autonumber)
Farm Name - stored data
etc.
When the report runs the number instead of the name is
showing up. I tried changing the fields to combo boxes
and copied the row source info from combo boxes on forms
that work to bring in the correct data but have not been
successful.
Thanks for your help,
Walter

 

[Allen Browne]

Create a query that combines the main table and also the lookup tables.

Open your report in design view, and change its RecordSource property to the
name of this query.

If some of your lookup fields are blank (Null), use an outer join in your
query, i.e. double-click the line joining the 2 tables in query design, and
choose the 2nd or 3rd option in the dialog. More information:
http://allenbrowne.com/casu-02.html