Hello --
It's a common procedure to duplicate a master record and its related records, though it's not a "native" FileMaker function: this implies the need of creating a script that duplicates the master record and isolates its related records using a search or a relationship
The ExecuteSQL function introduced with FileMaker 12 now allows to create a completely modular procedure, a sort of "object" that can be re-used in any situation, just passing to the procedure tables and fields names.
Accessorily the procedure is deadly fast :)
Link: http://www.buliga.it/tipfile_execsql.html
(where you can also enjoy some aulic italian description of the file ...)
Ciao
G. Pupita
Certified FileMaker 10 Developer
FileMaker Business Alliance