AUTOMATICALLY RESTARTING AUTONUMBER IN 1 to Many situation-TOUGH!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear Highly Esteemed Access Gurus,

Thanks for reading my post.

Ok, the situation is that I have a database with a one-many relationship. So
one customer, with one customer reference can have many items of different
types such as:

CUSTOMER 1
4 pots
2 plates
9 cups

What I want to achieve is that for customer 2, the numbering starts all over
again so for customer 2 the numbering will start again from 1 for pots,
plates amd cups.

At the moment, for customer 2, the numbering continues from 5 pots, 3 plates
10 cups but I want it to restart, or can i use filters? please suggest.
I am desperately in need of help and I have been trying to solve this for 2
months now with little success. Please Help.
 
Could you please post your tables. Just the names of the tables, primary
keys, and foreign keys, and which fields are using autonumbering.
 
Back
Top