Using the table name supplied the function returns the value of the primary key on the last record of the specified table at the time of the penultimate update. For tables that have multiple key fields the function will concatenate the fields together to return a single value. The function will return the same value for every record.
PENULTIMATEPRIMARYVALUE ( <table_name> )
-
table_name: The table from which to retrieve the penultimate primary key value.
We recommend that fields that contain this function be left un-indexed.
Example: Create a field on the INDIVIDUAL table that shows the primary key of the last record at the time of the penultimate update of the table.
PENULTIMATEPRIMARYVALUE(Individual)