Need a way of issuing revision numbers to id numbers - resetting per id number
I am using FileMaker Pro 10.0v3 on a Mac OS X - database stored on FileMaker Server.
I have a question - Is it possible to get FileMaker to assign sequential revisions numbers in a field based on an id number field that resets per id number? ie: id #NTS001 rev #01, NTS001 rev#02, NTS002 rev#01, etc.
How the database is set up is with an id number database and a related revisions number database. The two fields are id number and rev number that I am having an issue with. The rev # db is viewed via a portal in the id # db.
Is it possible to get the database to do this? or do I need to manually add revision numbers?
Thank you in advance for your help.