Need a little help on this...
I have a multi-page form.
On the first form, I have an ID field, First Name, etc.
In the Form Completion Events I have created an event (Dynamic SQL) to insert those records into a custom table.
The custom table has an ID field that is set to a uniqueidentifier, my insert sql stmt is "INSERT INTO mytable(FName,...) VALUES($(FirstName),...). When the record is inserted the ID field is populated (SQL Svr table) with a unique id...
How do I retrieve that value to populate the hidden ID field on the second form?
The reason for this is that I need to then do an update stmt (Dynamic SQL Event) for the fields in form2.
Basically, "UPDATE mytable SET my fields = form fields WHERE id = $(ID)".
I'm not sure if this is the best way to accomplish this, any ideas would be appreciated.
My form has over 100 fields and I don't want to put it all into 1 form.
Thanks,
Jon