5 Replies Latest reply on Sep 10, 2010 12:33 PM by philmodjunk

    Need a way of issuing revision numbers to id numbers - resetting per id number

    bate01

      Title

      Need a way of issuing revision numbers to id numbers - resetting per id number

      Post

      Hello,

      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.