>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