Good day, My client finally determined that he wanted to be able to look at a lot number (intended for a bar code) and make sense of it. We settled on YYYYMMDD#####. However I would like to autonumber that column but can't figure out if thats possible. I'm thinking I am going to have to programmatically control the number or at least the use of a trigger to find the last number of a date used +1). This is escaping at this time. Any thoughts appreciated.
Jan p.s. considering proposing YYYYMMDDHHMMSS
