0 Replies Latest reply on Dec 18, 2014 4:10 AM by GrahamKeogh

    Create Unique Job Numbers Per Client

    GrahamKeogh

      Title

      Create Unique Job Numbers Per Client

      Post

      Hi all

      I currently have two fields that together create my job number. It's a combination of a 'Client Code' (which is a identifier for an accounts package) and 'Job Number' which then I combine together in a calculation to make the job number that is used throughout my database.

      My question is I was wondering is there a way that when I create a new job the number will automatically increase by one, but per client. So if I have an existing job for client called say AAD1034, I want to be able to create the next in line, so AAD1035.

      However, if I make a job for another client in between say a job for client BAA1430, it messes up the numbering. Then when I add a new job for the AAD client it will create AAD1431, and not AAD1035 as needed. Hope this makes sense.

      Thanks a million as always