Serial Number by Calculation?
So, I need some help. I'm trying to set up an automatic serial number generator, but I want it to be specific to the records category. For example, lets pretend I was organizing movies by comedy and drama. I would like the drama ones to be D-001, D-002, etc. but the comedy to be C-001, C-002, etc. If I set up another field with a drop down menu to chose comedy or drama, would there be a way to make an automatic serial field that basically says "if field x = comedy, create next 'C' serial number, else, create next D serial number? Originally i was working with 2 separate tables, but that was causing other issues.
I would LOVE any input anyone may have. Thanks!