4 Replies Latest reply on Feb 22, 2011 10:48 AM by BatuhanGizer

    Assigning a unique value according to a different field value

    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.