MAX NUMBER

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... Received on Wed Aug 23 2006 - 06:39:15 CDT