Solved Auto increment number based on machine number coloumn

[Ravi Kumar]

Dear all ,

In my table want to auto increment the spool number based on my machine number column :
i don't know how to explain this problem in depth , hence i am attaching my sample database , please help me.

 

[Ravi Kumar]

Thank you so much ..

 

[arnelgp]

you can also use Data Macro (After Insert) to increment the Spool_number.
With or without any Form, the field will be incremented.

 

[arnelgp]

that i easy to implement. comparing the value of [counter] to the value of spool_number.