< 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 > |