AnsweredAssumed Answered

Best way to duplicate record + related records?

Question asked by jwagner on Jan 6, 2009
Latest reply on Jan 6, 2009 by jwagner

Title

Best way to duplicate record + related records?

Post

My FM database has the following structure:

QuoteHeader

QuoteLines

QuoteSubLines

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).

Outcomes