GetNextSerialValue function

Contents > Functions reference (alphabetical list) > Design functions > GetNextSerialValue function

GetNextSerialValue function

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.

Important See Design functions for information about literal text parameters.

Data type returned

text

Description

Returns the next serial number of fieldName in fileName. Field names must be fully qualified in the form tablename::fieldname to specify a field that exists in a table different from the current table.

Example

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

Contents > Functions reference (alphabetical list) > Design functions > GetNextSerialValue function