AnsweredAssumed Answered

Duplicates

Question asked by hspiegl on Feb 22, 2010
Latest reply on Feb 22, 2010 by 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. 

Outcomes