when i try to append a record to another table i get an error saying it can't due it. the error says.
Microsoft access se 0 fields to null due to a type conversion failure, and it didn't add 5 records to the table due to key violations, 0 records due to lock violations, and 0 records due to validation rule violations.
any ideas? i have a one to many relationship on these tables. but the table i am trying to append to does not have a primary key.

Check to see if you have any fields indexed but allowing no duplicates.

the only field i have indexed with no duplicates is the primary key field. but i am not tring to append to that table.

i got it to work but i had to remove enforce referential integrety from the relationships of my tables and now sorting through records is very slow. any ideas?

Apparently, you have 5 bad records in the recordset you are trying to append. Why not fix the data problem rather than removing referential integrity? Forcing Access to allow you to add BAD data to a table can only lead to future problems.

i just removed all the data in this database and tried it and it did the same thing. it seems that as long as i have referential integrety turned off it works fine. i am flustered. what i have is three tables 1 main one with a primary key and 2 others with a number field(not primary key). the numbers are both long integers. i need to be able to copy all records that equal that number in all tables and put them in thier respective places with the new number. I made two temperary tables for the two tables without primary keys. I made a append query that takes the data from the existing record and puts the new number with it and the another append that takes that data and puts it in the old table with the new number. i did this for both tables. it works fine except for the referential integrety. HELP!! please.