I need another incremental field in a table.

F

Frank Martin

The autonumber field in my table is used already as a primary key.

I want to introduce another incrementing field to use as a "sort" field in
my "InvoiceLines" subform so that the lines are always in sequence.

How do I do this in the "InvoiceLines" table?

Please help, Frank.
 
D

Douglas J. Steele

AFAIK, you can only have 1 autonumber field in a table. You'll have to add a
numeric field and take care of assigning it a value yourself.
 
Top