[thelist] asp/vbscript array problems

[Pringle, Ron]

> <snip>
> : 
> : Basically, its an events calendar that can have multiple 
> dates assigned to
> : an event. For each date for a particular event there can be 
> Agendas and
> : Minutes assigned to it. Because there are multiple dates 
> for events, I
> : have
> : to grab the last dateID from the eventDates table so that I 
> can increment
> : it
> : by 1 for each event date and write it to the committeeDocs 
> table to create
> : the relation between the two tables.
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> 
> Warning, Warning, Warning!
> 
> Why don't you just use an autonumber field (assuming Access) 
> and have the
> DBMS take care of generating the IDs for you? You can use 
> SELECT @@IDENTITY
> to get newly generated IDs if required.
> 
> Cheers
> Ken

Ken-

Actually I do use the autonumber field to generate the dateID in the
eventDates table. But I have to know what the number is going to be so that
I can create the relationship to it in the related committeeDocs table. I'll
check out the SELECT @@IDENTITY though, thanks!

Ron