>i create table(serialnumber with 2 field sequnce char(16) and DocNumber char(16)). i run myform,via my new method via your code,
The way the code is designed, for the sequences, you need a table called SerialNumber.dbf.
This table has to have a field called Sequence, and an index on that field. BTW, I don't know why the command SET ORDER... is commented; I think it has to be included.
The sequence table also needs a field called NextNum, which will store the next number that will be assigned.
The field DocNumber was just an example, of a field where you want to store a sequential number. This would be in another table. Just create a test table for this purpose.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
