I need another incremental field in a table.

  • Thread starter Thread starter Frank Martin
  • Start date Start date
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.
 
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.
 
Back
Top