How can I set a number field in a table to be auto-increment.
Basically the same concept that is used in MS Access, where the field value is automatically incremented when a new row is inserted.
thanks in advance.