append query problem

[kivenage]

what does it mean to have key violations? i have an append query that adds new users to a table from another linked table. but it says that none were added due to key violations. i've checked to make sure that the fields involved have the same attributes. has it anything to do with PK and FK?

please advice.
thanks

 

[Graham T]

Key Violations in action queries

A key violation occurs if:

• You attempt to run a query that appends, deletes, or updates records in a way that violates the rules of referential integrity for related tables.
• Your query attempts to append or update records that contain primary key values that already exist in the destination table.

If you run such a query, it will not modify the records that cause the key violation.

If you let us know what records you are trying to insert (including field names and data types) and what fields your append to table includes then we may be able to advise further

HTH

Graham