AnsweredAssumed Answered

Creating serial number from calculation?

Question asked by RyanMcCoy on Nov 3, 2012
Latest reply on Nov 5, 2012 by philmodjunk

Title

Creating serial number from calculation?

Post

     I have a fairly simple problem for you guys.  As you can see in the screenshot, I have a table that stores all my cues from all of my shows.  The cues each have a unique ID which cannot be modified and relates it to a particular show.  What I need to do is perform some sort of calculation to determine when creating a new cue if any cues exist for that show; if not begin numbering them at 1, if so, begin numbering at the last one present after incrementing by 1.  Hopefully you can understand what I am trying to achieve. If not, I can try to be a little more clear. 

      

     Thanks!

ss22.PNG

Outcomes