You could also have the system generate a GUID on the parent record and store it in a hidden field that you could use to bind the child records to the parent record by pushing the GUID instead of the EntryID.. Create the GUID on opening the parent record if the GUID field is null, and use this.
Use Application-Generate-GUID in a Set Fields Run process to generate it. Joe ----- Original Message ---- From: "Grooms, Frederick W" <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, October 15, 2008 4:49:33 PM Subject: Re: Creating subfile records from list on submit We put a Display Only "Processing ID" field on the 3rd form and have themain form push to the 3rd form (Standard Phase 2 action). All workflow on the 3rd form takes into account if Processing ID is Null or not. i.e. Data validation takes place if Processing ID = $NULL$. If Processing ID != $NULL$ then it pushes data to the subform (again standard Phase 2 action). Just to keep things clear we rename Modified Date and Last Modified By to Touched Date and Touched By and have our own Modified Date and Last Modified By fields that are filled in by a filter when Processing ID = $NULL$. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Wednesday, October 15, 2008 3:44 PM To: [email protected] Subject: Creating subfile records from list on submit Dear List, I have a main form and a subfile form. The subfile has two (actuallymore, but this is just for illustration) fields, a Parent ID field that contains the Entry ID of the main form, and an Info field. On submission of the main form, I use a filter to retrieve a list from a third form, then process that list to create subfile entries. Eg, it would retrieve a list like: abcde hijkl mnopq Then if the main form Request ID is 87 it should produce subfile entries of: Parent ID: 87 Info: abdde Parent ID: 87 Info: hijkl Parent ID: 87 Info: mnopq. So, on submission of the main form, filters process the list, and moveeach entry on the list into a temp field and do a Push Field to create the subfile record. Here's the problem. Push Fields get deferred to phase 2, and by thattime the temp field is overwritten so no subfile records get created. If I add `! to the end if the filter name, the filter runs in phase 1, but the main form Entry ID hasn't been created yet. The ideal would be to run the workflow in an Active Link "After Submit,"but there are times when the main form itself is created via Push Field action, so the Active Links won't run. Any suggestions? (ARS 7.1, patch 3, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
