Autonumber in ID

A

andrew3254

Hi, I might be missing something stupid here but...

Is it possible to have 3 field keys,

What I got is Customer ID, Department reference, autonumber and i want
something like:

342 - ELEC - 1
342 - ELEC - 2

343 - ELEC - 1

etc. Is there a way of getting the autonumber to reset for each customer id?
 
A

andrew3254

Customer ID is a foreign key linked to a customers table, this is in text
format as there is no need for calculations on it.

Department reference is simply an abbreviation of that deaprtment, a text
value also. There are different departments but these have different tables
for each department.

The last section is a sequential number I want to help group record by
customer, and department

e.g. if it is the first customer in the department for electrical say

101 - ELEC - 1 and if they have another transaction that will be 101 - ELEC
- 2.

and if another customer has a transaction it works on the same basis
102-Elec-1 etc.

I have tried using DCount but that doesnt seem to work, it just seems to
total up ll the records.
 
Top