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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Append Crosstab Query to Existing Table 0
sqlite-odbc write conflict 2
MS Project Center-Autolink column fields 0
comparing table values 1
Use of query to add sequential numbers to a table. 4
Auto Increment composite key 1
List all tables, including document structure 0

Top