Creating serial number from calculation?
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.