Hi Mark,
IMHO (in my honest opinion) it is much needed functionality that not only applies to duplicate invoice numbers but a range of other fields including those expressed in Mike James' New Idea Enforce duplicate Reference warnings.
Whenever an attempt is made by the user to move focus from such fields a validation routine should fire and if the value entered by the user has been duplicated then an appropriate duplicate error message dialog box should be displayed and the focus remain on that field in which the error occurred until the user has entered a value that can be validated as being a new and unique value.
It is not a matter of making sounds or doing anything other than what I've said in the above paragraph; the appropriate duplicate error message dialog box should be enough to indicate there is a problem with the value that has just been entered.
Kind Regards
Tony Lane - Tazinx - Ulverstone - Tasmania
Running AR2012 with "Win 7 Home Premium on Intel Core i5CPU @ 2.80GHz 3.00 GHz 32-bit, 4GB (3.23 GB usable RAM) desktop PC and 400GB Free space"
This is general information only and you should consider if this is appropriate for you.
Related Content
- 5 months agoWolfie2011
- 10 months agoSu3
- 2 years agopace