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 | Test 4 |
Hi
prevent duplicates
NOT(
IN(
[_THIS],
SELECT(
table[column],
([KEY] <> [_THISROW].[KEY])
)
)
)
https://www.googlecloudcommunity.com/gc/Tips-Tricks/Maintaining-Unique-Entries/m-p/263724
User | Count |
---|---|
20 | |
13 | |
8 | |
3 | |
2 |