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.
Roi
'MCP' Visual FoxPro
In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!