P
PetroChris
I'm trying to append values into a daughter table, when parent table records
do not exist. I get an error message that records were not added due to a
key violation.
[Parent].[ID] is an AutoNumber primary key field and is the only required
field in this table
[Daughter].[ID] is an AutoNumber primary key field
[Daughter].[Parent_ID] is a foreign key in the daughter table linked to
[Parent].[ID]
In relationships, I have a one-to-many relationship established by linking
[Parent].[ID] to [Daughter].[Parent_ID] with "Enforce Referential Integrity",
"Cascade Update Related Fields", and "Cascade Delete Related Fields" all
checked on.
I have a simple append query appending 3 fields from separate table into the
daughter table. It won't work. Help!!!
do not exist. I get an error message that records were not added due to a
key violation.
[Parent].[ID] is an AutoNumber primary key field and is the only required
field in this table
[Daughter].[ID] is an AutoNumber primary key field
[Daughter].[Parent_ID] is a foreign key in the daughter table linked to
[Parent].[ID]
In relationships, I have a one-to-many relationship established by linking
[Parent].[ID] to [Daughter].[Parent_ID] with "Enforce Referential Integrity",
"Cascade Update Related Fields", and "Cascade Delete Related Fields" all
checked on.
I have a simple append query appending 3 fields from separate table into the
daughter table. It won't work. Help!!!