Re: MS Access sequence numbers

From: Michael D. Long <lead_dog_at_bellsouth.net>
Date: 2000/05/08
Message-ID: <fHIR4.3764$en1.43576@news4.atl>#1/1

You aren't going to see the number that will be posted to the database until the trigger fires.

As an alternative you could remove the sequence from the trigger and call it from code and perform a manual assignment when the record is made active. This will result in the occasional skipped sequence, but it should suffice if you truly need to display the number.

Mike

<chrisjlewis_at_my-deja.com> wrote in message news:8f7inb$ctb$1_at_nnrp1.deja.com...
> Hi all,
>
> I've got triggers on my Oracle database to increment sequence numbers
> for my primary keys. How can I get Access (2000) to read the next
> sequence number before saving the record so that I can see it when I
> open a new form??
>
> Thanks,
> Chris
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon May 08 2000 - 00:00:00 CDT