Datapage Submission Form - Modify Key Field

[mbogen52]

Table A has a key field called HeaderKey.  Table B has a key field called DetailKey.  HeaderKey is a field in Table B.  I use a parameter to pass a HeaderKey into my DataPage Submission form.  The form displays fields from table B.  I am having trouble using the same field values to generate (submit) a new record with a different auto key value.  How can I change the key value?  I get a duplicate record error - it seems to be acknowledging the existing key.

Thank you

Mike

[aam82]

You want HeaderKey to be an autonumber on Table A only.

On Table B, HeaderKey should be an Integer datatype.

Pass Table A.HeaderKey as a parameter to Table B.HeaderKey, as a hidden field (on load receive value).

On Table B, DetailKey can be an autonumber so that individual Details can be called.

 

This will allow for one-to-many or one-to-one relationship between HeaderKeys and DetailKeys.