HI, I have a small DB. I have field call “City” and it’s got 13 plus cities.Now I’m trying to crate serial number base on city every time I crate a new record.
If I have choose Ottawa I want the serial number 1, 2, 3, 4, 5 etc. If I choose Montréal should be 1, 2, 3, 4, etc.
How can I do that? -- Suren
