Asset numbering according to Group and sub group

[nhkhurum]

Hello,

i Have list of fixed asset and i want to categories the same

Main Group 01
>>Sub Group 01
>>>>Asset code 0101 001 (last three digit incremental when any group is selected\\\

for example
01-Mech
01 Crane
001 Crane 100 Ton (Asset Code will be 0101001)

Last three digit autogenerated




plz advise how it is possible in access

 

[jdraw]

I recommend 1 fact 1 field
So Group,SubGroup, Dmax(your3digitnumber) +1

 

[nhkhurum]

can you send me attachment

 

[nhkhurum]

or plz share any fixed asset software keepin inview my requirements