Lookup code

rbuser

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

digitalmetaphors

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