AnsweredAssumed Answered

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

Question asked by bate01 on Aug 2, 2010
Latest reply on Sep 10, 2010 by philmodjunk

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.

Outcomes