>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.

You can do it with SQL by joining every record in the table:

SELECT TableA.* FROM TableA, TableB
WHERE Tablea.Field1 = Tableb.Field1
AND Tablea.Field2 = TableB.Field2...

etc