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 7101 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

Hi,

I have a question for anyone out there that can help me. I created an auto-serial number in an edit box that would create a record number for a set of five values. Now, I would like to have one value have a certain set of numbers (say 1 - 100), while having the other four drop down values have an auto serial number value of say, 101 - 1000.

I tried doing a calculation with an if statement and a case statement. The problem that occurs with either of these methods is that the four combined values I'm trying to create each have their own individual set of values. For example, value 'B' would start at 101, then if I would add a new record, say value 'C', it would, also, start at 101. This would occur for the other two values, as well. Basically, I'm trumped as how to combine values 'B' through 'E', so that they will be combined instead of individualized for the new record number 101 - 1000.

What would be the best approach for this auto serial number situation? A script, or...?

Thanks for any help any of you could offer me,

Cordially,

--R

This topic is 7101 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.