Combination Matching with 2 Tables

[Norman Belanger]

Hi

I have 2 tables where a combination of Table1 must equal the combination in
Table2 in order to get a match.

For example recordset 1 and 2 of Table1 and Table2 would be a match.

Table1

Field1 Field2 Field3 Field4
Field5 Field6 Field7 Field8(Result
Update)
rs1 Account # y a z
b x Table1 Data1 Table2 Data1
rs2 Account # u v
x w Table1 Data2 Table2 Data2
rs3 Account # x x x
x x Table1 Data3 Table1 Data3
rs4 Account # u v
x x Table1 Data4 Table1 Data4

Table2

Field1 Field2 Field3 Field4
Field5 Field6 Field7
rs1 Account # y z
x Table2 Data1
rs2 Account # u v
w Table2 Data2
rs3 Account # x a
y x Table2 Data3
rs4 Account # u v
x x Table2 Data4

Basically I'm trying to update Field8 in Table1 with Field7 of Table2 data
if a match occurs. Otherwise I want Field7 of Table1 to remain.

I tried different thing and finally got something going but it takes forever
to run. I actually have 13 fields to cross check

Thanking you in advance,

Norm