Once you have the new table, combined, use that table as your recordset to which you link a form to input new data. I never intended that you should run this procedure over and over to get your end result. It was a means to normalize your data so you could go forward. Lose your old tables and use the new one. Otherwise you will be in for a long chaotic challenge to maintain your database. Get it right and use it.
Alan
the problem is i have 2 source txt files that is updated regularly for my IN and OUT shipment that's why i have the NGK IN and NGK OUT tables. Would this be a problem using the modified DB you created for me?