AnsweredAssumed Answered

Auto Fill Calculation - Last Entered Record

Question asked by WilliamStone on Jan 27, 2011
Latest reply on Jan 27, 2011 by raybaudi


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.