Auto Fill Calculation - Last Entered Record
One of the fields in my database contains a unique ‘Job Number’ that is entered manually. So that I know what job number to enter in my new record I have created a field that contains the previous job number. My problem is that when I sort the records the previous job number displayed is not the last entered causing confusion when entering the latest job number.
I have used the following calculation:
GetNthRecord ( Job Number ; Get ( RecordNumber ) - 1 )
What calculation would I need to use to populate the field with the last entered job number and not data from the previous sorted record?
Hope this makes sense.