>Yeah, looks like it should work. I would probably do something like this:
>
>

>FUNCTION IsDup
>LOCAL llDupRec
>
>SELE LOCAL_HIV
>SCATTER MEMO NAME oRecOne
>
>SELE CDCHIV
>SCATTER MEMO NAME oRecTwo
>
>IF COMPOBJ( oRecOne, oRecTwo )
>  *Duplicate
>  llDupRec = .T.
>ELSE
>  *not a duplicate
>  llDupRec = .F.
>ENDIF
>
>RETURN llDupRec
>

>
>Good luck,
>John


REMINDER, this only works on a record by record basis, it could take a while if you are calling it in a scan loop. If you just need to check 2 tables and want to do it quicker, use something like what Brian Givens suggested.

John