Pre-Set Numbering

G

Guest

My firm tracks its meeting minutes in a database and numbers each meeting
sequentially and each item is number sequential as well. I have created a
table with uses these two numbers as the primary key and no duplicates are
allowed. I was wondering if there was a way to set up the numbering system
to automatically number the items in a meeting sequentially. Right now it is
being done manually.

The numbering system is meeting number: 01; item number 01. So in the
primary key is 01.01.

Jana
 
J

Jeff Boyce

Jana

How would you propose that Access would "know" what the proper sequence was?
If you give Access a pile of items, you could tell it which meeting to
connect them to, but what about the items determines their sequence?

Good luck

Jeff Boyce
<Access MVP>

"(e-mail address removed)"
 

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