Change what prints on a report

[Guest]

I have a parent table named "Learn" with 2 fields; an autonumber field(pk)
and a text field. I have a field called "Lrn" in a child table named "App"
that looks up the fields in table "Learn" and Binds the autonumber field.
When I print reports the autonumber prints. I would like to continue to
store the autonumber in the child table but would like the information from
the text field in the parent table to print on my report. How can this be
accomplished?

 

[Rob Parker]

I guess that you're basing your report on the "App" table, which contains
only the autonumber from "Learn".

To display the text, what you'll need to do is create a query which contains
both the tables, join the linking fields in each table (making sure you
select the correct type of join), and then drag the fields you want from
each table into the query grid (I'm assuming that you'll use the design view
to set up your new query); you can omit the "Lrn" field from the "App"
table, and include the text field from the "Learn" table. Save the query,
and then base your report on the query.

HTH,

Rob