|
| 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
July 26th, 2006, 11:48 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
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
July 26th, 2006, 03:29 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
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 |
Linear Mode
