AnsweredAssumed Answered

Nested Duplication of Related Records

Question asked by russbrad on Aug 22, 2012
Latest reply on Aug 23, 2012 by MarcDolley

So I've successfully got duplication with related records working, and a slightly trickier version involving creating new records:

 

https://fmdev.filemaker.com/message/90759

https://fmdev.filemaker.com/message/92148

 

However, now I'm trying to duplicate a record, with related child records, and a second level of related child records, which are grandchild records of the original record.

 

Here's the pseudo-code:

 

  1. Duplicate source record
  2. Go to related child records
  3. 1st-level loop
    1. Duplicate record
    2. Go to related grandchild records
    3. 2nd-level loop
      1. Duplicate record
      2. Go to next record
    4. Go to next record
  4. Go to duplicate record
  5. Profit

 

It's at step 3D that I run into a problem. I don't know how to return to the found set that I established at step 2. It seems to me that step 3B clears the existing found set, but if that's not the case, I'd like to know how to return to the previous found set.

 

Message was edited by: russbrad

Outcomes