I am getting closer. I changed the 6 individal table code fields to unique names. I used to have all 6 tables with first field named "lookcode" and second field named "lookdesc" now I changed to "lookcode1" "lookcode2" "lookcode3" "lookdesc1" "lookdesc2" "lookdesc3" and so on. It didn't give me the SQL - column lookcode error. Now I have a new error, "SQL - Column Lookcode6 is not found." So I think it got a little bit farther. It used to stop at Lookcode1. Getting closer...