Prevent a duplicate of a certain value

Nedave · 04-04-2025 08:22 PM

I have a unique issue. I have a contact table that has records ID, AcctNum, Primary, Name....

Primary is Yes/No

I need a way to only allow a record to be only 1 Primary per Acct and as many No as needed

For Example

ID	AcctNum	Primary	Name
2	2	Yes	Test 1
3	2	No	Test 2
4	2	No	Test 3
5	2	Yes <<<This needs to fail with Primary Contact already Exists>>>	Test 4

jballester

Hi

prevent duplicates

NOT(
  IN(
    [_THIS],
    SELECT(
      table[column],
      ([KEY] <> [_THISROW].[KEY])
    )
  )
)