We use the YYYYMMDDHHMMSS to give unique numbers to payments we process. I added a rule on the column that says the result must be unique to prevent duplicates. We have never had a problem and from an audit standpoint, you can easily tell who is working early and who is working late.
Dave Fitts -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of jan johansen Sent: Monday, January 14, 2008 8:01 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Lot numbering 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
