PLACING NON-LINKED FIELDS IN SUBREPORT

[kissarmi]

I have a subreport linked to the main report by an identifier. Within this subreport I need to place some fields from a separate table that is not linked. There is a code within the subreport table that corresponds to the record in the non-linked table.
Example situation: The subreport lists buildings owned by a particular entity. On the listing under each building are codes for the type of construction, like plumbing, floors, roofing, etc... I need to also print the description of these codes, which are kept in a separate table that includes the code (and code_type to keep it unique).
How do I extract the description fields from the code table and place them on the subreport.

Example code would be helpful, if possible.
Thanks

 

[synapsevampire]

You should have a link from the code in:

"codes for the type of construction, like plumbing, floors, roofing, etc..." I need to also print the description of these codes"

to the code in the

"which are kept in a separate table that includes the code (and code_type to keep it unique).
How do I extract the description fields from the code table"

Now add in the description field for the code.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com