Duplicating record including related one-to-many records
I'm sure there must already be a simple answer to this question, but I can't find it.
I have a table of Customer Quotations, with each record related (by quoteID) to a "many" table containing a list of items that the customer has selected. If, subsequently, there is a need to change the items originally seleted, rather than edit the original quote, I want to duplicate it and also the "many" records that it related to, then edit those. Its this last bit that has got me foxed. I could loop through the "many" record, duplicate each and paste in the new QuoteID, but this seems a laborious way to achieve what I want. Is there a simpler way?