Validation Error on append query

[laura reid]

Hello,

Could someone tell me why I'm receiving the following error:

MS Access set xx fields to null due to a type conversion failure, and it
didn't add 0 records to hte taable due to key violtions, 0 records due to loc
violations and 0 records due to validation rule violations. Do you want to
run anyway.

When I run anyway, the query works as I want it and my records append.

Here's what I think. Table I'm appending to is the table that holds the
'many' side of my relational database. The fields I'm appending too are the
FK fields, and the data I'm putitng in the FK fields are the corresponding ID
numbers so the information relates. However the FK fields in the 'many'
table use the table design lookup tabs. I think its somewhere in here that
i'm 'missing the magic'.
Is it recommend I fix this error, and if so where should I start? I can
live with it if the end result is it's giving me the right records (which it
is).

Thanks
Laura

 

[laura reid]

Hello,

Could someone tell me why I'm receiving the following error:

MS Access set xx fields to null due to a type conversion failure, and it
didn't add 0 records to hte taable due to key violtions, 0 records due to loc
violations and 0 records due to validation rule violations. Do you want to
run anyway.

When I run anyway, the query works as I want it and my records append.

Here's what I think. Table I'm appending to is the table that holds the
'many' side of my relational database. The fields I'm appending too are the
FK fields, and the data I'm putitng in the FK fields are the corresponding ID
numbers so the information relates. However the FK fields in the 'many'
table use the table design lookup tabs. I think its somewhere in here that
i'm 'missing the magic'.
Is it recommend I fix this error, and if so where should I start? I can
live with it if the end result is it's giving me the right records (which it
is).

Thanks
Laura