4 Replies Latest reply on Dec 15, 2011 9:47 AM by MikeDunne

    Duplicating record including related one-to-many records

    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