I am in the consignment business and every item has to have a unique number, and for years have struggled with how to do this. What I do creates a long string but since I use barcoding its no problem. I do the following in a temp table: Set a temp autonumber col, say -Tauto (Employee ID+yymmdd+Tauto)
With this I can imediately tell who and when inventoried it. Since I do some work at home(not on the network) the item# is always unique. This seems to work for me but if someone has a better way I would love to know> Tom ----- Original Message ---- From: jan johansen <[EMAIL PROTECTED]> To: RBASE-L Mailing List <[email protected]> Sent: Monday, January 14, 2008 7:00:39 AM 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
