I am using a Valid If expression to flag up a duplicate entry which works great.
NOT(IN([PONumber], SELECT(Customer Orders[PONumber], [CustName]=[_THISROW].[CustName])))
The problem I have is if I go back and need to edit the row, the duplicate warning flags up and prevents me from saving any changes. What am I missing?
LinkedIn
Twitter
