Lookup in Crystal

[enbw]

I am reporting on a 3rd party database which crystal reports on through temp database files. I am looking to report on two of these tables. One contains the Job operations and the other contains the Job materials. Materials are related through the job operation number. But the operation description is in the Job operation table.

The report displays the list of materials with the related job operation number. I want to be able to show the job operation description which resides in the job operation table. The two tables are linked. Is there a way to lookup the job operation description from the material operation number?

Thanks in advance

 

[synapsevampire]

SInce you have these 2 tables in Crystal, and they're linked, the description field should be available.

Rather than trying to describe technical information with text, consider providing technical information in a technical fashion:

Crystal version
Database used (3rd party isn't very helpful)
Tables used
Example data
Expected output

-k