key violations in append query: please help

[Guest]

I am trying to append a variable number of records from one table in one
database to a second table.

One example has three records to be appended, the first two records append
ok, the third however, won't due to a key violation. I have looked at the
data in the append query for the three records and nothing stands out is
being odd, there are no primary keys set in the destination table. and no
indexing of any form on the destination table.

For the aqbove append i am getting a key violation for the thrid record of
the append and it won't add, i cant's see anthing int he append query for
that record that could cause a problem.. please help

 

[Ken Snell \(MVP\)]

Key violations result from one of two things:

1) the data in a field would violate an index in the table;

2) the data in a foreign key field have no corresponding data value in the
parent table's field.

No way to give you a more solid answer than.... you need to carefully look
at your data for Nulls (where none are allowed), the absence of a
corresponding value in a related, parent table, etc.

Frustrating, but believe me when I say -- once you figure out what the error
is, it will seem so obvious.

 

[Guest]

thanks, if found the error

was to do with the relationship definitions in teh destination table

cheers: happy new year