try un-checking the "in-range" box and see if that works. But I would keep the Max number of characters checked.
That didn't work. I unchecked the in-range validation, but it still won't let me leave the field blank..I also tried unchecking the max characters and it still won't let me have a blank emr id field.
I'm open to other suggestions.
Unless somebody else chimes in with a better solution, I would write a script to check for the unique value to be fired from a script trigger. That way you can have an "IF" statement that if the field is blank to exit script, but if not check for duplicates and then show a custom dialogue.
1 of 1 people found this helpful
all of my related tables are using the EMR id as the foreign key. Guess I have to rethink all of this!
Definitely: Seems EMRID# carries meaning, which is not a good thing for a primary key.
Employ a real, unique, always-entered and meaningless ID to use in relationships; then simply display EMRID# in the related tables.
that is good advice! thanks, Linda