I have an estimating database with line items. I have created a record which is an estimate template. This template record contains a group of line items i wish to be able to optionally 'import' into any new estimate.

I tried to set up an import script then realised i cant import from the same table.

So i am trying to duplicate the template records and then copy the new EstimateID into the EstID field to link them to the new record.

I have created a script which goes as follows:

go to Layout [Estimating]

Go to field

Copy

Enter Find Mode

Paste

Here is the sample script to duplicate record found set

My method: (Works on the found set in the current layout)

Set Variable (your new ID)

Go to Record/Request/Page

[ First ]

Loop

Duplicate Record/Request

SetField (Variable (Your new ID)

Omit Record

Go to Record/Request/Page

[ First ]

Omit Record

Exit Loop If [ Get ( FoundCount ) = 0 ]

End Loop

Not sure why your opening new windows all can be done in the current window with a go to original layout at the end if you do a GTRR to find the working set of records.

Edited April 15, 201015 yr by Guest