Using the table name supplied the function returns the value of the primary key on the last record of the specified table. 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. It is recommended that fields that contain this function are always left unindexed.
LASTPRIMARYVALUE ( <table_name> )
-
table_name: The table from which to retrieve the last primary value.
Example: Create a field on the CUSTOMER table that shows the primary key of the last customer record.
LASTPRIMARYVALUE( [CUSTOMER] )