Append Query to multiple tables

[databasedonr]

I'm trying to take a flat database (all records in one table) and make it relational. The flat table contains contact information, phone, address, customer type etc. information, and I want to pull these out to appropriate tables ie. address table, phone table.

There is no primary key on the existing table; I have designed the new tables with primary and foreign keys.

I want to move the data from the existing table to the new tables, and am trying to do this in one append query -- without success. Am I crazy? Can I make this work? Would love to hear any ideas. Using Access 2000

Thanks in advance, and greeting from snowy cold Canada - -19 C at the moment and snowing.

 

[databasedonr]

Thanks Pat -- that works -- I was hoping to build a killer query that would do it all at once, but. Now my tables are populated!

Thanks again.

LAF