Thank you for your replies. No, I don't have to keep the auto numbers in Table A. But how do I make the new record with Auto number. No, there are no duplicate values between these two tables. There are no overlapping numbers,. I can use the append query if I can use auto number going forward...