Creating a sequential number help

[tb1]

Hello,

I am trying to create a counter per case number. Since several customers can have serveral different case numbers and each case numbers can have multiple inquiries.

Basically it goes like this...

Customer1 has a Customer number
customer1 has a case number
each time that particular case is called upon, I need to have a counter for that case number.
I'd like the end result to look like this.


Case num - Counter
123 - 1
123 - 2
123 - 3

etc....

Can someone please help me with the code. I would post the Dmax code I am using but I am certain its wrong since I need to have the number increase everytime the customer calls in about the case number.

Any help or guidance is appreciated..

 

[Rx_]

This is probably more of a DB Table Desgin than a VBA question.
You need a Customer table with an autocounter (new customer - new number)
then a Case Number table (autocounter) that has a Customer Number as a foreign key.
This way, if the same customer later needs a different case - the one to many relationship is there.
If a case has different versions - then a table with an autocounter for each service detail. Consider using a sequence of Dates / Time for this and not showing the autocounter itself.

http://www.access-programmers.co.uk/forums/showthread.php?t=115281&highlight=tracking
This site has a very valuable Sample Databases area
Went to the Sample Database and searched thread with "tracking"

I realize this is an IT tracking demo. It has the users (e.g. customer) then a customer's asset (e.g. computer - support item for you) then that assets software inventory (e.g. support list for you)
The concept is very much the same - the source code is there to change the descriptions.
This demo is great because it includes a Word document description.
A demo that you can use and look into may give you some answers for questions you will encounter.
Hope this suggestion is appreciated.

 

[tb1]

I will try all of this out. Thank you