I have table A with an autonumber field called A_ID. I'm trying to append these records into table B which as one autonumber field called B_ID and also the field A_ID. Table is new and empty. When I try to append A_ID from table A to table B it appends 0 rows because of validation rule violations. What does this refer to? The only field I'm appending is A_ID into table B. Also field A_ID is a Long Integer in both tables.