Append Query

[nickysquawkes]

I have a database with a table linked to an Excel spreasheet. I am trying to create an append query to load data from the linked table into a candidate table. Each record in the candidate table has a candidate number which is automatically generated and is the primary key. When I run the query it cannot update the table because of key violations. I haven't got the candidate number as a field in the append query, do I need to put it in there? and if so how should it be setup? Any help would be much appreciated.

 

[KenHigg]

You shouldn't have to put the aut pk fld in the append query. Does the table you are appending to have any fk flds?

 

[nickysquawkes]

Thanks Ken thats what I thought. Excuse my ignorance, but what does FK stand for?

 

[KenHigg]

Foreign Key. Does this table have any other relationships? Is it the many side of a one to many relationship with another table?

 

[nickysquawkes]

Yes it does. It is the many side and the 1 side of relationships

 

[KenHigg]

Then I'm guess that the query is telling you (with the error message), that you are trying to appened records on the many side that do not have an associated on the one side... Make sense? (I'm not very good at explaining these types of things )

 

[nickysquawkes]

This is the message I get.

 

[KenHigg]

Sorry, I'm not sure I can explain any better what your problem is...

 

[nickysquawkes]

Thanks anyway Ken. Can anyone else help?