[AccessD] autonumber

Drew,

So you have everything back to normal in your new pad and are just
sitting around twiddling your thumbs? <grin>

As I said in another post, auditors do not like to see missing numbers.
So why try to explain to them when you can use a real incremental number
for humans(?) and save the AN for RI purposes.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: Drew Wutka [mailto:DWUTKA at marlow.com] 
Sent: Thursday 2003 Apr 17 04:43
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] autonumber


I'll have to look through the archives myself on this one.  (I'll have
them running this weekend...for me! <grin>  SBC says my DSL will be up
next Thursday (barely a week, yippie!)).  (Actually, in case anyone
forgot, http://intranet.marlow.com/AccessD still works...it just doesn't
have anything after this past January/December (and it's not  as fast as
what I had online for a whopping 36 hours...<grin>))

I always thought that the only real cardinal sin with AN's, was to use
them as a true incremental value.  (ie, expecting that if there is a 2
and a 4, that there is also a 3).

I personally don't see any harm is using the AN for purposes other then
a key, nor do I see any harm with showing the user an AN, though a lot
of times, a user just wants a number, so it doesn't matter if it's an
AN, or something else.

I know I probably just opened a HUGE can of worms, but heck, I had
intermittent List time (been busy with other things), however since 11
pm on the 15th (it's now 4 am on the 17th), there has only been 70
posts.....come on folks...that's pathetic?  JC, what can we argue about?
We need more posts!  <evilgrin>

Drew