Skip to Content
0
Sep 05, 2023 at 01:08 PM

Formatted Search - Duplicate

105 Views

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])