I have a submission form datapage with the checkbox "On exit, pass ID and formula fields as parameters" checked.
On exit, the datapage redirects to a separate datapage with a report with edit capabilities.
Each datapage is based on separate tables so simply put, I want to stamp the primary key from the first table as a foreign key in the 2nd table.
My problem is, how do I receive the ID (primary key) in the 2nd datapage.
I am pretty sure this should be configured as an external parameter but how do I format the value so that it inserts the ID from the first table? I can't select the ID anywhere in the datapages.
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.
Question
hctrr
I have a submission form datapage with the checkbox "On exit, pass ID and formula fields as parameters" checked.
On exit, the datapage redirects to a separate datapage with a report with edit capabilities.
Each datapage is based on separate tables so simply put, I want to stamp the primary key from the first table as a foreign key in the 2nd table.
My problem is, how do I receive the ID (primary key) in the 2nd datapage.
I am pretty sure this should be configured as an external parameter but how do I format the value so that it inserts the ID from the first table? I can't select the ID anywhere in the datapages.
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
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.