AnsweredAssumed Answered

Duplicating record including related one-to-many records

Question asked by MikeDunne on Dec 15, 2011
Latest reply on Dec 15, 2011 by MikeDunne

Title

Duplicating record including related one-to-many records

Post

Hi, Guys

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?

H

Outcomes