Append Query simple query

[MercuriAl]

Hi all
I'm having a dim moment!
I have two tables each with an ID field (autonumber/PK/No Dup etc).
I want to append two fields from one table to the other table. I have set up an Append Query to do this but it won't work - I get the following error - "The INSERT INTO statement contains the following unknown field: 'FiID'...."
I know this is something simple but it's doing my head in!!!
Any ideas?
Many thanks

 

[Cronk]

You cannot create 2 new fields in a table with an append query.

Add the fields in table design, then use the append query to add the data.

 

[MercuriAl]

Hi Cronk
Thanks for the reply.
I was not trying to create two new fields.
I have been trying different things and have eventually got it to work by deleting the ID field in the supplying table.
It still seems strange to me but hey! it works.
Thanks for taking the time.
Cheers