In one BO I have 2 fields, DesignDate and DrillNumber. Design Date defaults to CURRENT_DATE and Drill Number is auto increment and resets whenever the design date changes. All is good
EXCEPT
On Friday, the user creates a new record and then changes the date to Monday. All looks good, it has Mondays design date and drill number 1. However, when on Monday the user creates a new record, it will have the same design date (Monday) but has also has drill number 1. Now I have 2 duplicate records. This used to work properly way back when (a few versions ago.)
Bruce
