Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

Lookup code

edited August 2002 in End User
I have a table which has a code field in it. I would like in the report
to print the meaning of the code, not the code, which is in another
table. I know how to do the grouping, not the look up information. How
would I go about this?

Table 1

Name address city code

Table 2

code
code description


Report

Code Description
Name address city

Code Description
Name address city


Thank you,

Brian

Comments

  • edited August 2002
    Lookups can be handled using a master detail report. Please take a look at
    the master detail section of the Developer'sGuide pdf in your RBuilder
    installation. You will need to create a detail dataset linked to the master
    dataset. Connect this new detail datapipeline to the subreport and place
    the subreport in the detail band of the main report.


    Cheers,

    Jim Bennett
    Digital Metaphors

This discussion has been closed.