hi,
i tried the script and loved it..thank you..
but one problem i faced..if i delete few records from the database/or entry form.. then new record takes the next no as id...how can we use these missing ids(ids deleted)

No, You can't recover the deleted IDs. If you want to specify IDs, then you must create another ID field.