Need Two Autonumber Fields In One Table

D

Dan

I am trying to construct a table that has two fields that
need to be incremented after each record is inserted. I
have the autonumber function set for the 'record id'.
The other is a 'call number' field. Does anyone know of
a way set the default for such a field to one more than
in the previous record? Thanks.
 

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

Top