insert query

[adamides]

I have the following query:
--
INSERT INTO GoatPerformance ( FemaleAnimalCode )
SELECT FemaleAnimalCode
FROM Matings;
--
it does not insert the values of FemaleAnimalCode from Matings to GoatPerformance. It gives me the following error message:
"Farm Management set 0 fields to Null due to a type conversion failure and it didn't add 0 records to the table due to key violations 0 records due to lock violations and 9 records due to validation rule violations"

Can anybody help?
Thanks

 

[adamides]

OK, I got it to run basically some fields were required in the other table and I fixed that. Now my problem is that I want to call a query from a form and when the user enters the KiddingDate to append that value in another table, also. How can I do that? How can I specify only the specific form value to be inserted in another table?

Thanks