>Thanks Craig for replying,but if i want to create a autolog number and if i dont want any break in between,can't i do it with Vpf8 autonumber.
>
>In access the autonumber is assigned only when you save can't we get the same behaviour
>
>

If you don't want a gap, use the PK routine on my website. However, I recommend using VFP 8's autonumber for PKs over my routine.