Sapna, I assume you have something like a primary 'real' form with data, then a child 'real' form with data, and you are using the display only from as a console, right? If that's the case, you then have a primary/foreign key structure going on that links the two tables together to give you your relationship. What I would do is do it via filters. I would create a new display only field on both named 'CopyToNew', and another display only field named 'NewID'. When you want to make the copy of all of the records, I would perform an AL Push to the primary form setting 'CopyToNew' to "Yes', and setting 'NewID' as the new linking ID that you want to use for the new set of records.
Then you have a filter that fires on Modify of Primary form if 'CopyToNew' = "Yes". This filter does two things...it creates a new record in the parent form with matching ID's. It also performs a push to all of the child forms using the current primary key and modifies all of them setting the 'CopyToNew' to Yes, and the NewID to the same value that was pushed to the parent. On the Child form you have a similar filter that fires on modify using the same conditions as the first that makes a new copy of this record. Then you create another filter for the parent and child that fires on submit. This filter fires if 'CopyToNew' = "Yes" and the NewID field is not $NULL$. What this filter does is a simple setfield action to set the current 'key field' (whatever its name is) with the value in NewID. When this process is done, you have cascaded your copy action from the console, to the parent, and from the parent to the children, all of the records have made a copy of themselves, and the new copy replaced its key field with the new value. From there you could refresh your console with the 'new' record's info. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Sapna Motwani Sent: Thursday, July 28, 2011 11:54 AM To: [email protected] Subject: Need to create cascaded duplicate record Hi, I need to create a "copy to new" like feature on a display-only form. On the display only form i have one character field that has multiple associated records displayed in one main table. And every record of main table has multiple records in dependent tables. I have to create a button with functionality similar to "copy to new" feature of Remedy user Tool. So that i can copy all the records displayed in tables with new character field value. I have created active link guide/Active link to copy main table entries with new character field value. Any help would be appreciated. Regards, Sapna _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
