Well I can't update 1 table until I update the other table. I think I need to do it at the same time in the same statement or it will error on me. What I wanna say is:<BR>Update table1, table2 where idfromdropdown = typeofpage and set table1.ID = idfromdropdown where idofpage = typeofField and then table2.ID = dropdowndropdown where typeoffield from table1 is = to the ID in table 1 that corresponds with the ID in table 2. How is this done? I hope that makes sense.