Prevent users creating blank records
Does anyone know a way of preventing users creating blank records and leaving gaps in a sequence of serial numbers? For example the user opens a layout and selects new record (record number 50) but then realises they have selected the wrong layout and exits the layout thereby leaving the record blank. The next user opens the layout and another record is created ( record number 51) but this leaves the previous record (record number 50) blank.
Is there someway I or FM can either, prompt the user to fill in all the required fields or, better still, exit the layout without creating a record leaving the serial numbers in sequence? I have looked at Serial Number | Generate | On Commit rather than On creation but FM still creates the record with the serial ID. I have trawled the forums and I can’t seem to find anything that really does what I want it to do, so any help would be appreciated.