whschimmel
Thread Starter
- Joined
- Jul 7, 2008
- Messages
- 168
I've got an database, in this database there are made some callnumbers
this number is create like this:
customer # + Year + Month + number, this results in:
851000-2008-09-00001 (without the '-')
I would like to change this number so it wil create sequence per dealer, so when a other dealer is selected, the number re-starts with 00001, like:
851006-2008-09-00001
can anybody help with this?
Tnx,
Wouter
this number is create like this:
customer # + Year + Month + number, this results in:
851000-2008-09-00001 (without the '-')
I would like to change this number so it wil create sequence per dealer, so when a other dealer is selected, the number re-starts with 00001, like:
851006-2008-09-00001
can anybody help with this?
Tnx,
Wouter
Attachments
-
173.9 KB Views: 6