S
skennell
I want to append related records from two tables into a similar set of two related tables. The primary key of the main table I need to append INTO is an autonumber field related to the "many" side table's number field . I know I need to append the records from the Main table into the new Main table, then append the "many" side table into the new "many" side table. However I get a conversion mismatch data type error when trying to append into the Main table's records. I believe it is due to the autonumber field. How can I append into both of the new tables while maintaining the one-to-many relationship with an autonumber field? Thanks.