Reference > Functions reference > Design functions > GetNextSerialValue
 

GetNextSerialValue

Returns the next serial number of fieldName in fileName.

Format 

GetNextSerialValue ( fileName ; fieldName )

Parameters 

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 

text

Originated in version 

6.0 or earlier

Description 

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