Pre-Set Numbering

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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)"
 
Back
Top