>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.
OK -- whatever works.
regards,
Jim Edgar
Jurix Data Corporation
jmedgar@yahoo.comNo trees were destroyed in sending this message. However, a large number of electrons were diverted from their ordinary activities and terribly inconvenienced.