Autonumber & Field combination

[zrobinso]

Hi,

I am not that good at Access. I have a table that tracts counselors by [EDCNumber].

In a seperate table, I track ever company the counselor works with. What I need is an autonumber field that adds the [EDCNumber] plus the next number to be used, called [CaseNumber].

EXAMPLE:

EDCNumber CaseNumber

445 44501
445 44502
446 44601
447 44701
447 44702


Any help in the right direction will be greatly appreciated.

 

[UncleJack]

Autonumbers are fine for indexes, but should not be used for real data. Certain procedures can reset autonumber fields and destroy relationships.

To find the next available number in a table use the DMax function increasing it by 1.

NextCaseNumber = DMax("CaseNumber", "CasesTable&quot + 1

Uncle Jack