9 Replies Latest reply on Oct 27, 2012 3:12 AM by RickyFarr

    Avoiding duplicate records when importing: ID



      Avoiding duplicate records when importing: ID & Modify fields (FMP 11)


      Hi all.

      I am making a series of modifications and - hopefully - improvements to a database which is in use by 2 different users (Filemaker Go on iPads).  This means I will be importing records from both users into new versions of the file, lots of times, then sending them back out.

      I need to check on importing records whether any records have the same unique ID field, AND the same Modification Timestamp. If they both match, then I need to stop the matched records from importing.

      Can I do this?? It would save a lot of manual checking & deleting.