Best way to duplicate record + related records?
My FM database has the following structure:
Each quote my users create will have at least 1 QuoteLine record, which in turn will have at least 1 QuoteSubLine record. My users want to be able to replicate an existing quote into a new quote record, including the lines and sub-lines, as this would save a lot of data entry. What is the best way to script this? (I'd like to have a button on the quote screen that would copy the data from the current record into a new record, with a new quote number).