Hi Brian, I don't have an answer, but will be following the thread.
Regards, Tony -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brian Hancock Sent: Saturday, October 07, 2006 7:21 PM To: DataPerfect Users Discussion Group Subject: [Dataperf] Extracting values from newly created record from CreateRecord From Panel List Hi Guys, I have a web survey which has questions which are number 1 to xx. Each survey has a SurveyId. The survey returns to DP all these pieces of data via a Transaction Log, putting them as name-value data pairs in a panel which is used to temporarily collect data. There will be one record per name-value pair. eg the 4 records might be Name Value ---------------- surveyid 7659 Q1 Y Q2 N Q3 Y In my application all the "input: is performed by a report and I am putting these results in two panels: Response and ResponseInstance The "Response" panel stores the Survey ID and also has an incrementing ResponseID field which is the Primary Key for this record (it use Ralph Aly's et al absolute-incrementing-on-a-network using a Recursive Link technique) A child (panel link) from that panel is the "Response Instance" which collects the responses to each question. My problem is, that the parent table has an incrementing number which is its primary key, and I need to use that value in each other the child records. My question is how do I retrieve the ResponseID from the newly created record, as in: ══CREATE RECORD LINK/PANEL: 0 19 ══ -----Store Report Variable 201 in Field 5 ------ /* ie SurveyID */ /* I now want the incrementing ResponseID but the record isn't saved*/ ══SAVE RECORD══ As soon as the ══SAVE RECORD══ occurs you are dropped out from the Subreport. So you can't check it after the SAVE. If I stored the ResponseID in an RV before the SAVE RECORD I risk that number not being correct it another user is adding a record at the same time, as the Absolute Incrementing of the ResponseID field occurs when the Record is Saved. (With the incrementing using a recursive link it is possible for two user to initially get the number which is resolved at Save time.) I have thought about putting another Create Record to the Child Panel inside the Create Record and then refer back up the link for the ResponseID but that creates a blank record which ignores things such as ::M indicators, and I am not ready at this point to populate the child records. Any guidance would be greatly appreciated Regards Brian _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
