One possibility
- add a 3rd field to the index (I doubt it matters if you set "ignore null" to yes or no)
- pad 3rd field with zls (zero length strings) for all records except the ones you want to have dupes in.
This would mean that your data entry would have to insert zls in all records of 3rd field except for the odd time you want to repeat a combination.
Might be better to remove the index and control data input through your form by looking for the proposed combination via DLookup and if found, don't allow form save. Or do you, sometimes? that's the fuzzy part.
Last edited by Micron; 06-20-2022 at 09:47 AM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.