>I have tableA with thousands of records.
>I have tableB with just a few records.
>I need to grab a WHOLE record in tableB and and search for that WHOLE record in tableA.
>
>Is there an easy way to search for a WHOLE record in another table? Each record has 70+ fields.
>
>Any comments will be welcome. Thank you in advance.

I don't know an easy way... a hard way is:

scatter tableb
lfound = .t.
select tablea
scan
    for nfieldcnt = 1 to fcount()
         cfielda = "tablea." + field(nfieldcnt)
         cfieldb = "m." + field(nfieldcnt)
         if eval(cfielda) # eval(cfieldb) then
             lfound = .f.
         endif
    next
    if lfound then
       * got a match
       exit
    else
        lfound = .t.
    endif
endscan
if lfound then
    * found match processing
else
    * no match processing
endif