Ammend Query - Validation Rule Error

[M8KWR]

I have a table that I am trying to map to other via an ammend query.

I keep getting a validation rule error, so it will not populate the table with the data from other.

Does anybody know why this would happen, as the field types for all the fields i am trying to map are the same, or the one that I am trying to enter data to is slightly bigger in length.

I have done this before with no issues, but this one is causing me hassle, and I do not know why.

I have even tried building the query field by field, and some fields work ok on there own but others do not, and can not work out why either.

Please help, thanks for your help in advance...

 

[Remou]

Hi
Have you looked at the validation on the fields in the table you wish to update / append to? Have all your key fields got data? Have all the fields that are set to Required got data? That's all I can think of. Hope I have understood your question.

 

[M8KWR]

all the fields within the table i'm trying to get data to has no key fields as such.

There is about 100 fields within this table, and i'm only trying to match about 20ish.

The table is completely empty before i try and ammend data into there.

This has worked for me in the past with none of this issues, i do not know what i am doing wrong.

 

[Remou]

Hi
If you are getting a validation rule error, it means that one (at least) of the fields you are trying to change is violating at least one rule of the table you are trying to append to. So you need to check each of the fields in the table you want to append to - all 100 of them - to see if they:
1. Are Indexed
If a field is indexed for no duplicates, does your data contain duplicate data for that field?
2. Are Set to Required
If a field is required, does your data contain an entry for that field?
3. Have a validation rule
For example, are linked to a lookup. Are set to >10. Does your data match?
It might be easiest to create a new table containing only the twenty fields you want to append, and test against that. Hope this gives you some ideas.