In a form there are 3 text boxes – assetid, quantity, amount. When i enter 3 in the quantity and click a save button, assetid should auto increment from com1 to com2,com3,com4 consecutively in access database column and at the same time the amount should be divided equally among the 3 assetid and saved in the database.