Append Validation Rule errors (Using text fields!!!)

[Kobus-Dippenaar]

Good day,
I must be getting old, Many times I have appended tables. But now I am struggling even trying to append 4 fields defined as text.
Please view attached zip file.

 

[spikepl]

I believe very few people are willing to download a pig in a poke (which is UK-English for something unknown and nasty in a zip file).

You better say what your actual error is and how you create it, and what supporting stuff you put into the zip.

 

[plog]

In PatientT the fields [TimeFrame], [CostCode], [Birthdate] are all required and you aren't appending anything to them with that query.

 

[Ranman256]

you are adding only a few fields, but you have SEVERAL indexed fields.
Because of this , you CANNOT add nulls. all indexed fields MUST have a value.
either put these fields in the query
or
dont index the field.

 

[spikepl]

So, apparently people are willing to download pigs in pokes

 

[JLCantara]

Plog is right; Ranman is wrong; Spikepl: keep your silly comments for your friends...

 

[spikepl]

Pardon me. For people of the French persuasion, it is probably: pïg in a pôke.

 

[Kobus-Dippenaar]

Thanks to the appropriate answers.
I forgot about the required fields, I was struggling with a full query, using all the fields and the override (continue yes) did not work. Hence out of frustration I just selected a few fields. Thanks I am going back to check the required fields.

Will comments soon.

Blessings.

 

[Kobus-Dippenaar]

Thank you. The Problem is solved.
Much appreciated.
Blessings to all.