An Auto-Enter, Unique, Serial Number, by calculation field can be created.
How to populate a field with a unique ID
Answer ID: 9903Last Updated: Feb 27, 2012
<SNIP> If desired you can also combine text as part of your unique serial number. This might be helpful in cases like part numbers that might be a combination of text and numbers. In the “Next Value” field in the “Field Options” dialog, format your serial number using text and numbers. For example, if you used ABC1, then FileMaker Pro would create unique IDs like ABC2, ABC3, ABC4, etc. FileMaker Pro will only increment the last number used in the “Next Value” field. So, for example a “next value” of ABC1XYZ1 will get incremented as ABC1XYZ2, ABC1XYZ3, ABC1XYZ4, etc.
Home > Designing and creating databases > Creating a database > Setting options for fields > Defining automatic data entry
To save time and ensure accuracy, you can set FileMaker Pro to automatically enter data in text, number, date, time, and container fields. For example, FileMaker Pro can enter the current user's name into a field.
Create and display this number how you like, but do not allow it to be a substitute for a straightforward indexed serial number as the key field.
Get(UUID) in Filemaker 12 is becoming my prefered link instead of the serialized ID number since crashes and corrupted files are possible. If UUID is used you don't have to worry with duplicated serial numbers.
Using Album Name & serial id is a waste plus its redundent (OK, records, tapes, CDs, etc...).
When you are using a relational database you only need the serial id (YUCK) or the UUID to establish a link
When you use barcodes, the link will take you to the record and you can derive visible data from it for your layout.