OOOH, That sounds like a cool way to do it to me!
Could you also pull the trick with arrays? Is there an array compare function?
>Hi Morys,
>
>This is just a guess (I didn't test it), but would compobj work. You could select tableA, scatter a record to object, then scan tableB, scattering to object again for each record and compobj to see if the records match.
>
>hth
>
>>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.
--Todd Sherman
-Wake Up! Smell the Coffee!