I have a table (Table A ) with 3000 records. Primary key is auto number. The company already has another table (Table B) with around 6000 records, with primary key -Numbers. The numbers in Table B are manually entered, not auto numbers. The company wants to retain the existing numbers in Table B for a valid reason. I need to combine both tables ( columns are same ) and going forward, the number should be auto number for new records. Please let me know whether it is possible. Please guide me how to do that if possible.
Thanks for your help.
Thanks for your help.