Reference > Functions reference > Design functions > GetNextSerialValue


Returns the next serial number of fieldName in fileName.


GetNextSerialValue ( fileName ; fieldName )


fileName - the name of an open database file (local or remote).

fieldName - the name of the field whose next serial number you want to determine.

Data type returned 


Originated in 

FileMaker Pro 6.0 or earlier


Field names must be fully qualified in the format tablename::fieldname to specify a field that exists in a table different from the current table.

Example 1 

GetNextSerialValue ( "Customers" ; "CustID" ) returns the next serial number for the CustID field.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas