I'd like to have a developer layout that shows at a glance the Next Serial Values for all data tables. I'd like to see the values that actually display in the define fields Auto Enter tabs in the "next value" field rather than doing a SetNextSerialValue (TableName::Serial_#;Max_Serial# = 1). Is there a Get(NextSerialValue) function or equivalent that will do this? TIA

FMA9 on Win XP

GetNextSerialValue(file name; table::field name) function is in the Design functions section. The parameters expected are TEXT, which is unusual.* That is so you can define them for files and fields which may not be present at the time (such as differently named files, which is possible during an update routine).

At least that's what I remember, haven't used it much lately. You would definitely want this Unstored. I've never used it for display, but don't see why it wouldn't work.

* Maybe Get (File Name) would be OK for same file, better, Quote ( Get (File Name))