>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.
If you wish to take control over that sequence, I would suggest you use another field. This functionality is the same manipulation as a primary key. A primary key serves for a primary key, and if visual manipulation of a specific field should be done, I believe you would be better to use another field for such purpose.