G
Guest
Parent Table
PKey - ParentTable_ID - Autonumber - Long Integer - Incremental
Field 1
Field 2
ETC
Child Table
PKey - ChildTable_ID - Autonumber - Long Integer - Incremental
FKey - ParentTable_ID - Number - Long Integer
Field1
Field2
Field3
Field4
The four fields are indexed "Yes (duplicates allowed)
The Parent related to the Child One Parent to many Children
PKey Parent to FKey Child
I created subform based on Child Table and added to Main Form based on the
Parent....When I try to add data in the subform I get the following message.
The changes you requested to the table were not successful because they
would creat duplicate values in the index, primary key, or relationship.
Change the data in the field...........etc.
All suggestions appreciated. Thank you.
PKey - ParentTable_ID - Autonumber - Long Integer - Incremental
Field 1
Field 2
ETC
Child Table
PKey - ChildTable_ID - Autonumber - Long Integer - Incremental
FKey - ParentTable_ID - Number - Long Integer
Field1
Field2
Field3
Field4
The four fields are indexed "Yes (duplicates allowed)
The Parent related to the Child One Parent to many Children
PKey Parent to FKey Child
I created subform based on Child Table and added to Main Form based on the
Parent....When I try to add data in the subform I get the following message.
The changes you requested to the table were not successful because they
would creat duplicate values in the index, primary key, or relationship.
Change the data in the field...........etc.
All suggestions appreciated. Thank you.