AUTOMATICALLY RESTARTING AUTONUMBER IN 1 to Many situation-TOUGH!

W

word_novice

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.
 
M

mnature

Could you please post your tables. Just the names of the tables, primary
keys, and foreign keys, and which fields are using autonumbering.
 

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

Similar Threads

AUTOMATICALLY RESTARTING AUTONUMBER FOR NEW CUSTOMER- TOUGH! 2
Multiple autonumbers in a many to many relationship 4
Receiving unexpected Duration 0
Stop subreport from repeating 2
Have multiple subreports display entries only once 4
Help starting 1
Make Existing Field AutoNumber or Other Options 2
Checking one cell, if number is a range then this 4

Top