Hi,
I have a customer who wants to check for duplicate NumAtCard after the reference number is put in and not wait for the order to be saved.
I added a UDF and this formatted search, but when I click on the magnifying glass, it puts the word Duplicate in there.
I am not sure what I am doing wrong, can someone help?
SELECT 'Duplicate'
FROM ORDR T0 WHERE T0."NumAtCard"
IN (SELECT T1."NumAtCard" from ORDR T1
WHERE T1."NumAtCard" = $[$14.0.1] AND T0."CardCode" = $[$4.0.1])