AnsweredAssumed Answered

Assigning a unique value according to a different field value

Question asked by BatuhanGizer on Feb 22, 2011
Latest reply on Feb 22, 2011 by BatuhanGizer

Title

Assigning a unique value according to a different field value

Post

Hello,

I am creating a new database "Project Minutes", which  will have the information for a specific project meeting.  The only  problem left for me is to assign Project Meeting Number.  I have two  fields, Project Meeting Number and Job Number.  I want to write a script  that will automatically assign a Meeting Number whenever a Job Number  is filled in starting the sequence from 1.  The only additional thing to  this is to assign numbers for each different job number for example:

Job Number: 10060 Meeting Number: 1

Job Number: 10060 Meeting Number: 2

Job Number: 10060 Meeting Number: 3

Job Number: 10060 Meeting Number: 4

Job Number: 10070: Meeting Number: 1

Job Number: 10070: Meeting Number: 2

Job Number: 10070: Meeting Number: 3

Job Number: 10070: Meeting Number: 4

So meeting number is not globally unique but unique for each different jobs.  Is this possible?

Thank you.

Outcomes