AnsweredAssumed Answered

Serial Number by Calculation?

Question asked by wmixter on Jan 22, 2010
Latest reply on Jan 22, 2010 by philmodjunk


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!