I need your help
I have table with two uniq and required column.
Firsrt is a key value, there is no problem working fine.
And second one is prevent duplicate with this query:
NOT(COUNT(Select(Animals[VID], AND( [Farmer] = USEREMAIL(), [_THISROW].[VID] = [VID])))>0)
Everything is ok, but, when I edit the row, this query say that this column value is duplicated and I can’t save my changes.
How can I do that ?