QUE CORPORATION - Using Filemaker pro X
| < Day Day Up > |
GetNextSerialValue()
Category: Design Syntax: GetNextSerialValue ( fileName ; fieldName ) Parameters: fileName ”a string or text expression that represents the name of an open file; fieldName ”a string or text expression that represents the name of the field for which to return results. Description: Returns the next value for a field defined to auto-enter a serialized value. Examples:
GetNextSerialValue ("Invoices" ; "InvoiceID")
might return 5435 .
GetNextSerialValue ( Get (FileName) ; "Contacts::ContactID")
might return 84 . Comments: It's good practice to use TableOccurrence::FieldName syntax to reference the field in this formula so that it can be evaluated in any context. Without explicitly naming a table occurrence, this function assumes the field can be found in the current context, which may not be the case. Because the auto-entered serial number is defined at the table level, it doesn't matter which of a table's occurrences you reference; they will all return the same result. |
| < Day Day Up > |