I use coded domains for all of my streets (900+ records - don't judge me). When I need to add a new street to the domain table, I want to use the next available number. I know I can sort by code, scroll down to the end and add one to the last number for my new record.
My question is how do I avoid duplicating a number in the coded value field that is already being used?
I tested what might happen by adding a new record duplicating and existing coded value. I was surprised I didn't get a popup warning me I was violating data integrity. I believe what happens is that the original coded value gets deleted.
