My suggestion was to use a compound index. This would prevent the same combination of lastname, firstname, phone number. It is discussed in the referenced article.
My suggestion was to use a compound index. This would prevent the same combination of lastname, firstname, phone number. It is discussed in the referenced article.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thank you for your suggestion.
However, after reading the whole article two times, I still don't see the thing I want. Do I set the value to unique? How then can two out of three fields be the same? If I set the value to "allow duplicates", it defeats the purpose, don't you think?
As you describe the "compound index" it appears that is exactly what I'd like, but then with what setting?
Thanks,
Leen
The 3 fields combined would be defined as unique.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.