Hi,
I have created a user defined table and the unique field named 'Code' is a sequential number in the form of 00000001. Is there a way how this can be updated automatically when the user tries to add a row?
For example if the last line is 00000055, when the user adds another line, the code automatically populates as 00000056.
thanks
vankri