GetNextSerialValue
Purpose 
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.
Important  See Design functions for information about literal text parameters.
Data type returned 
text
Originated in 
FileMaker Pro 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.
Examples 
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