Duplicate whole record and linked Portal records.

Hi Craig,

It's not duplicating the portal records because those are part of a different table.

Your best bet is to create a new window and search for the related records in that. Something like:

Perform Find [Restore]

#New code goes after the find

If IsEmpty ( PortalRelationship::orderID )

Duplicate Record / Request

#nothing more to do since there are no related records

Else

Duplicate Record / Request

Set Variable [ $newOrderID ; Order_Item::_ORDID ]

New Window

Go To Layout [ layout based on portal records ]

Enter Find Mode

Set Field [ orderID ; $OrderId ]

Perform Find

If [ Get ( FoundCount ) ]

Loop

Exit Loop If [ Get ( FoundCount ) = 0 ]

Go to Record/Request [First]

Duplicate Record / Request

# The duplicated record is always added to the end of the found set, as long as the found set is not sorted

Omit Record

Go to Record / Request [ Last ]

Set Field [ orderID ; $newOrderID ]

Omit Record

End Loop

End If

Close Window

End If

Using a new window means that you won't have to worry about restoring the found set or the appropriate layout when you're done with the related records.

There's probably some more error checking that needs to happen, but this is the basics of it.

Then it's probably easiest to create a new layout without those triggers - or modify the script above to set a global variable (such as $$IGNORE_TRIGGERS) to True before creating the new window and make sure all your triggered scripts check this variable before doing what should happen when a user navigates to the layout.

Can also be done by using Get(FoundCount) to set a variable for the number of related items and using another variable to increase from one each time you loop to next record and duplicate. Exit the loop when the count equals the position (increment at the end of the loop) then go to first record and omit multiple using the Get(FoundCount) value. The remaining records will be the new duplicates that you can then apply the new order ID to with a Replace Field Contents.

There was a thread in the german Filemaker-Magazin forum on this topic here:

FileMaker Forum-Beitrag : Re: Best Praxis (Bezugs-)Datensätze duplizieren :: FileMaker Magazin

and my 5 cent was this post:

FileMaker Forum-Beitrag : Re: Best Praxis (Bezugs-)Datensätze duplizieren :: FileMaker Magazin

needs one fix:

$auftrnr = ExecuteSQL ( "

SELECT MAX(Auftragsnummer)

FROM \"Aufträge\"

" ; "" ; "" ) + 1

best regards

otmar

The example-solutions are in "FileMaker", so you should understand the script-steps. Look at the script "DUPLIZIEREN" between # --> and # <--