If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
AUTOMATICALLY RESTARTING AUTONUMBER IN 1 to Many situation-TOUGH!
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. |
#2
|
|||
|
|||
AUTOMATICALLY RESTARTING AUTONUMBER IN 1 to Many situation-TOUGH!
Could you please post your tables. Just the names of the tables, primary
keys, and foreign keys, and which fields are using autonumbering. "word_novice" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Specific "auto numbers" possible? | dl | Database Design | 10 | March 1st, 2006 07:44 PM |
PartNumber can be used as primary key | Kyle | New Users | 14 | March 1st, 2006 04:17 AM |
Need Subforms? | AccessRookie | Using Forms | 7 | April 8th, 2005 09:30 AM |
Access 2000, autonumber fields | Zyberg74 | General Discussion | 3 | November 17th, 2004 04:24 PM |
Autonumber | Ally H. | General Discussion | 7 | August 27th, 2004 04:51 PM |