This content has been marked as final. Show 2 replies
Try the WHEN-DATABASE-RECORD-trigger instead. This reduces the chance of gaps.
But, its still possible to loose numbers (users enters a record, then leaves the form without saving). Using sequences you will always have gaps in the numbers.
When I used when-database-record, my field does not shown automatically, hence I have put in the item trigger for when-item-validate, but still the same problem when the gap numbering appear if user exit the form without saving.