Change what prints on a report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lorraine - 29 Sep 2005 19:02 GMT

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?

Signature

Lorraine

Reply to this Message

Rob Parker - 30 Sep 2005 07:05 GMT

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

> 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"
[quoted text clipped - 3 lines]
> the text field in the parent table to print on my report. How can this be
> accomplished?

Reply to this Message