auto serial number control by ID

[hasru]

i trying to make a calculation in a auto enter serial number. what i tried to solve is how to split the serial number in the auto serial that was create by different location or different district.

example..if person at district A enter the record the serial number look as A0001 then person at district B enter a new record, the field's number looks B0001 and person at district C enter a new record, the field looks C0001. When person at district A again enter at new record, the field looks A002 and so on...that means the serial number should be the same numbers at every district but with the different character infront the number. hopefully everyone can understand my english.

tq

[aaa]

Do it by script:

When you create new record, first find all records for this: "A" or "B" or "C", then go to last record and increment serial number. This is one of ways, i am sure there must be many ways to do it.

[hasru]

i tried but still not works. please explain in detail.

[SlimJim]

Hi Hasru

The sample file here shows you another method without a script. The sample has one table with two fields District and ID. The Id is set up to auto-eneter when District has been chosen.

DistrictID.zip

[hasru]

tq for sending file but the sample file cannot create a new record to test. pls make all fields can be copy and be reuse for my task.

tq

[hasru]

THANK YOU, IT WORKS 100%. I CAN SLEEP WELL TONIGHT

[hasru]

hi again

i thaught i can sleep well but i can't. i tried recreate table by copying your fields. Field District and Field ID. i still dont know why it wont run as yours. my record appears like this.

district A A0001

District A A0002

District A A0002

District A A0002

District B B0001

District B B0002

District B B0002

that's mean the auto number just running 0001 to 0002 only and not counting.

[SlimJim]

This looks like the sorting in the relationship of District to District has not been applied.

The reason this method works is that you match district to district and then sort the related values by ID descending this make the first related record have the largest ID number and hence you can produce the next one by incrementing. I guess that in your case you have either not sorted by ID or you have sorted ascending.

[hasru]

i surender awhile. here i post to u and pls make a post mortem of what im doing.

data.zip

[hasru]

At last it running very well. tq for helping

[hasru]

i have to login again to ask some helps.

i used almost a month above calculation to auto serial number for different users. i realised that its do not working well in multi user enviroment.the number comes duble and tripple also. is there any way to make it works well in multiuser enviroment.

thanks