Hi Ralph,
I think I have found a kludgy workaround...
All the web reports are what you would call parallel report (or what I would
call sequential reports)... Everything runs inside a dummy container report
and the user does get to interact with DataPerfect other than via the one
report submission.
The way I have worked around it, is thar when I create the parent record,
prior to it being saved I create a record through the link, but instead of
storing to a field, I retrieve the data from the parent panel through a
datalink. This gets saved as an empty record. I then "Include SubReport"
back through the same link and perform a Delete record. Since there is only
ever one record, it doesn;t take too long, but it does mean that I get any
conflicts resolved with regards to the autoincrementing (recursively linked)
numbers value.
It would be interesting if there was another way, but I am now content with
this workaround.
Thanks
Brian
----- Original Message -----
From: "Ralph Alvy" <[EMAIL PROTECTED]>
To: "DataPerfect Users Discussion Group" <[email protected]>
Sent: Monday, October 09, 2006 9:13 AM
Subject: Re: [Dataperf] Extracting values from newly created record
fromCreate Record From Panel List
On Saturday 07 October 2006 19:21, Brian Hancock wrote:
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.)
Hmmm...at first thought, why not try to do this as a parallel subreport
process, where the first parallel subreport creates the parent record, and
the second parallel subreport would be a Lookup report that allows the
user
to select a Saved record from the parent panel.
Obviously the problem with the suggested solution is that the user as to
hunt
for the parent record he just created a second or two ago. If they're in
reverse date/time order that might be a bit quicker to see in the report
Lookup.
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
