Reiro wrote:
> 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...

If this is connecting to Oracle you should create a sequence and not be
doing manual numbering which will not scale.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org