It sounds like, when the database calculates the AutoNumber for the parent record, the tableadapter/dataset code is not picking up the change and setting it in the parent (which the client side relation then causes to transmit into the child table)
Right click your parent tableadapter, click Advanced.. Tell me, is the tickbox "Refresh Changes in the Database Back Into The Dataset" (or words to that effect) box ticked?
|