A predefined sequence of numbers

[PatOls]

HI,

How do you predefine a sequence of numbers, for ex.

User 1 places an order and gets ordernumber 15
on his order

another user places an order and get ordernumber 16
on his order

yet another user places an order and get ordernumber 17
on his order

anyone have any ideas?

//Patrick

[LAURENS]

Assuming you want to store those orders you could consider a SelfIncrementing field in your database. On every Add it will generate a new number. A disadvantage is that on a cancel of the add it will skip the generated number in the next record.

Like
Add -> 17
Cancel
Add -> 19