I am running the following code:

JOIN
LEFT_OUTER TTR.TTR.TTR_VIN_LAST8 AND TTR.TTR.TTR_VIN_FIRST9 IN TTR TO UNIQUE
CTS.CTS.CTS_VIN_LAST8 AND CTS.CTS.CTS_VIN_FIRST9 IN CTS TAG J0 AS J0
END
-*********************************************************************
-* *
-*********************************************************************
TABLE FILE TTR
PRINT
TTR_REQ_NMBR
TTR_VIN_FIRST9
TTR_VIN_LAST8
TTR_REQ_DATE
TTR_AUC_DATE
TTR_REQ_COMMENT
TTR_TITLE_NMBR
TTR_MAIL_COMMENT
TTR_AUC_NMBR
CTS_CT_MAIL_DATE
CTS_TITLE_IND
CTS_CT_AUC_NMBR AS 'CTS_AUC_NMBR'
BY TTR_VIN_LAST8 NOPRINT
BY HIGHEST TTR_REQ_DATE NOPRINT
WHERE (TTR_VIN_LAST8 EQ 'CF370933');
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE HOLD AS TTRF00A1 FORMAT ALPHA
END

This creates a report of multiple records. I only want to keep the first record. What is the most efficient way to do that?

Also, the final version of this will not have a specified value for the WHERE statement but an input box to allow the person to search for multiple values for a singe run.

Thanks for any assistance,
Mitch P.

This message has been edited. Last edited by: Mitch P.,

If this is only the first record of the returned recordset, then use WHERE RECORDLIMIT EQ 1

If its the first for each BY HIGHEST, then change to BY HIGHEST 1

Thanks, that did the trick.