Duplicate Customer Reference No
I am trying to stop entering Duplicates for Customer Reference No during Sales Order Entry by a formatted search.
Select case when NumAtCard in (Select NumAtCard from ORDR where NumAtCard in ('test11'))
then '' else NumAtCard end from ORDR where CardCode = 'AQU001'
Select case when NumAtCard in (Select NumAtCard from ORDR where NumAtCard = '$[ordr.NumAtCard]')
then ' ' else ''$[ordr.NumAtCard]'' end from ORDR
The above query is not working in formated search, I must be missing some thing, please advise?