AnsweredAssumed Answered

Dublicate record

Question asked by hanstrager on Jun 8, 2014
Latest reply on Jun 12, 2014 by hanstrager

Title

Dublicate record

Post

     2 minor things in my database have been annoying me for a very long time, but i'm not sure how to fix it.

     I have a database where I quite often dublicate records. I use the following script:

     Freeze Window
     Set Variable [ $RecordNumber; Value:Get ( RecordNumber ) ]
     Duplicate Record/Request
     Set Variable [ $TECHSHEETID; Value:TECHNICAL SHEET 2::xTechnical sheet_ID ]
     Go to Record/Request/Page [ $RecordNumber ] [ No dialog ]
     If [ not IsEmpty(Line Items Fabric::TechSheetID_FK) ]
     Go to Related Record [ From table: “Line Items Fabric”; Using layout: “LINE ITEMS Fabrics” (Line Items Fabric) ]
     [ Show only related records ]
     Go to Record/Request/Page [ First ]
     Omit Record
     Exit Loop If [ Get ( FoundCount )=0 ]
     End Loop
     Go to Layout [ original layout ]

     My first problem is when I have dublicated a record I want automatically to go to this new record instead of staying in the old record. is there a way to do that?

     Then I have a few Radio button sets, which all have auto enter data, (since these can't stay empty), but when I copy my record these radio button reverts back to my auto enter data. Is there a way to have the radio buttons stay the same as my dublicated record..?

Outcomes