Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 6047 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

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

This topic is 6047 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.