Jump to content
  • 0

Datapage Submission Form - Modify Key Field


mbogen52
 Share

Question

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

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...