I am trying to get the next serial value as :

GetNextSerialValue ( Get(FileName) ; Billing cases::Case )

But no value is returned ??

Also SetNextSerialValue is not seting the value either ? Anyone has this problem with FMP 8.5 Advance ??

What is your field type text or number?

You need to put the name of the field in quotes. The GetNextSerialValue() is a Design function, and most of those functions only accept a text value.

Edited June 7, 200718 yr by Guest
Deleted Quote()

Thank you for your responses.

This is driving me crazy. I have tried to change the field type to Text and back to number with no help. Also I used :

Quote( Tabel1::serial) with no help. The function just returns nothing !!

The field name must be enclosed in quotation marks:

GetNextSerialValue ( Get ( FileName ) ; "YourTable::SerialField" )

Using the Quote() function is NOT the same as enclosing the field name in quotation marks:

Quote ( YourTable::SerialField )

returns the CONTENT of the field enclosed in quotation marks.

Oops! Sorry.

Thank you so much guys. I got it !