asked on

Serializing Records By Category Filemaker Pro 11

I want to have an auto-enter field or a calculation field that serializes records by category. i have attached a sample of the database I have. I have four fields (Group, Name, Serial Id, and Max Serial Id). I have 1 table with 2 ocurrences. The field 'Max Serial Id' is based on a relationship from an occurrence of the main table that uses the max() function to show the largest 'Serial Id' value entered for a particular Name under a Group. I want to be able to auto enter the Serial Id number every time a record is created. The calculation should look into the Max Serial Id field and get the value and then add a 1 to the Seria Id value.
Serial-Number.fp7

North2Alaska

How about just calculating serial number? In order to do this, you need an additional field to "Break the tie". So I created a Date Created field and auto entered the timestamp when the record was created. Then added it to the join. One caveat; a record in the same group/name pair can NOT be created at the same exact second. If you feel comfortable with this condition, this will produce what you want.

Serial-Number.fp7

ThomDroz

PachecoPrimo
You can run a script that opens that table in a separate windows,
Then find all record, sort by field with serial number, go to the last record
Set a variable that equals the serial number field and then add 1

Hope that helps!
Tom

ThomDroz

Another option to having a serial number is to use a Universally Unique Identifier (UUID)

You will need filemaker advanced. Learn more about it here
http://www.briandunning.com/cf/1246

ASKER CERTIFIED SOLUTION

North2Alaska

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial