Hello Bill. Maybe you remember me from last night? Anyway, I am at the point where I need help again. I have two tables: Table1 and Table2. Basically I need to go through the recordset and do the following:<BR><BR>If Table1ID <> Table2.ID and Table1.Boxno = Table2.Boxno then<BR>update Table2.ID to be equal to Table1.ID where table1.boxno = Table2.Boxno<BR><BR>Does this make sense? I want to run this after a bunch of inserts, so the recordset needs to be opened?