We have two Access DB tables that need to be combined together. Table 1 has 20 fields and about 800 records. Table 2 has 10 fields and about 85 records. The first 10 fields are the same on both tables. They both have the same field names, the same size, type and are in the same order. Information for the last 10 fields will be added manually after the two table are combined. The last 10 fields are not on Table 2.
The main table (Table 1) has an automatically assigned autonumber whenever a new record is entered. Table 2 also has an autonumber for each record. We will not need the autonumber from table 2 when they are combined.
What is an easy way to combine these two tables. Once they are combined and tested, table 2 will be deleted. There are no duplicates. If we must use a special procedure, plese tell us where to put the code. We are using Access ver 7 in Windows.
Thanks for any assistance you can give.