hi ppl...

i am entering dat in an access front end connect to an oracle database.
i am using max (number) + 1 increasing my id...

problem is ... if during testing i enter a number like 9999999 in the
database.
Even whn record is deleted i get the next value as 9999999 + 1.
how do retrieve the maximum value that is in the table.

thx in advance...