I dissagree with using RECCOUNT(). This will open up a "can of worms" if you decide to PACK your table.

By using a SELECT MAX(field) you will get the highest value for that field which can then be incremented by one.