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
