I have several tables with auto incrementing fields. I use the field to have a definite unique record in the table. If the server is rebooted (NT go figure) it totally botches the count. For instance it may be a rec num 1050 then after a reboot it jumps to 500000001 ? ? ? Why does this happen? Is there a better way? Should I not use the auto incrementing field?