Philocthetes
Has a great deal to learn
- Local time
- Today, 05:19
- Joined
- Dec 19, 2017
- Messages
- 28
This might be another case where I'm doing something that seems logical to me but is database-brainless.
I've got a 'central' table, Titles, with an AutoNumber PK, Title_ID, which is an FK on several other tables, e.g. Print_QC. When I try a simple append of Title_ID from Titles to Print_QC, it doesn't "add 277 record(s)...due to key violations."
The destination field is neither AutoNumber nor a PK. I thought it might be the relationship between the FK and PK Title_ID fields, so I deleted the relationship. No change in behavior.:banghead:
I've got a 'central' table, Titles, with an AutoNumber PK, Title_ID, which is an FK on several other tables, e.g. Print_QC. When I try a simple append of Title_ID from Titles to Print_QC, it doesn't "add 277 record(s)...due to key violations."
The destination field is neither AutoNumber nor a PK. I thought it might be the relationship between the FK and PK Title_ID fields, so I deleted the relationship. No change in behavior.:banghead: