I am using crystal report XI with SQL as the database, I am using 2 tables from a database namely OEORDH and OEORDHO, the fields of the table are like this....

 

 

   ORDUNIQ        ORDNUMBR   CUSTOMER   CUSTGROUP  BILLNAME. ...

     4546                  QUT02            CUST01            GRI                XYZ             

     4610                  QUT03            CUST02            GR2                YYY

     4738                  QUT03            CUST01            GR1                XYZ

 

 

 

  ORDUNIQ         OPTFIELD       VALUE

    4546                OPTFLD1          ABCDE

    4546                OPTFLD2          DEFG

    4610                OPTFLD3           ASDF

    4738                OPTFLD1          ABCD      

 

these r the contents of the two tables, actually I am preparing a sales order report,  when i select a report of ORDNUMBR QUT02,I want the value  in OEORDHO to be printed of the of the respective  ORDUNIQ (ie value of 4546)

 

      To be clear when I select QUTO02 I want "ABCD" to be printed on my report.

 

     It will be very useful if any one please help out..

 

regards.