I want to create an auto generated code. lets say I have some products and I need to assign a code to that product. So the way I followed is:
I Created a list Item named "product code" here I gave the default value=Prod and concatenated the ID. Like =CONCATENATE("PROD",ID).
Every time when I am entering some data in list it is not updating. It is Updating only when we edit some thing in list item "product code" and also it is concatenating the ID only if we tick the ID in Dataview. Please enlighten me how can I generate autoid's.
Also another issue is: if I delete any List Item it is not coming with the next number say If created items item1,item2 if i delete item2 next if i add some data then next item is coming as item3 but i need the sequence like item2 must come.
Please help me in this regard
View Complete Post