10 Replies Latest reply on Feb 22, 2010 12:27 PM by hspiegl

    Duplicates

    hspiegl

      Title

      Duplicates

      Post

      Hi,

       

      I'm trying to resolve a script to check on duplicate records as data is entered. I'm using telephone numbers as the duplicated reference point.

       

      This script works fine as a script but when I have it triggered by Script Trigger (on exiting Telephone Number) it goes nuts and sits in a loop. I have to force quit filemaker.

       

       

      Set Field [ MPS Target Data Converted::Global; MPS Target Data Converted::telno ]

      Loop

      Go to Record/Request/Page [ Previous; Exit after last ] 

      If [ MPS Target Data Converted::Global = MPS Target Data Converted::telno ]

      Beep

      Show Custom Dialog [ Title: "Duplicate Record"; Message: "This is a duplicate record"; Buttons: “OK”, “Cancel” ] 

      End If

      End Loop

      Go to Record/Request/Page [ Last ]  

       

      Thoughts? Thanks.