Maybe use two columns, date and autonum id, then concatenate them in a
computed column?
Regards,
Alastair.
----- Original Message -----
From: "jan johansen" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Monday, January 14, 2008 1:00 PM
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
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.19.2/1223 - Release Date:
13/01/2008 20:23
