Incrementing numbers

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

I am trying to write a database that will allow for a
persons ID to be entered and how many items are associated
with this entity. Once the nuber of items have been
entered allocate an item type to each.

The record number or entity number is generated by the
Autonumber in the table and the number of items is added
by the user. The following is what I am trying to do

Case number ABC0004
Number of items 4
Item numbers to be allocated in table with type
ABC0004-001 Spanner
ABC0004-002 Crowbar
ABC0004-003 Hammer
ABC0004-004 Screwdriver

Please e-mail me off the list for any help you may have.

thank you

Keith
 
Back
Top