My Fellow FMers,
I've been mid level guy. However this time I stumbled on something and it seems can't go forward.
Here is my dilemma:
I created DB with records of products/items.
My company has the strict rules for serial numbers:
1VAL is always there, 12 means a year of manufacture, B means a second month, 123 is an actual serial number. ADVAC is a type of product.
12 - year can be obtained from "date created" field (auto-enter today's date), so is the month B from the date created (calculation).
Serial number starts for new month at 100, still OK and sequential number is done by adding 1.
My problem is that I don't know how to do a test if for SN it is next number or it should be 100 if the month is new.
Much obliged (in advance).