GST Billing Software

header image

Auto Incrementing MultiIndex Property

Erachana Line

12. What is AutoIncrementingMultiIndex Property? How it is useful?

In case of Single User Application, only one user accesses the database at a time and incrementing of primary keys don't have any conflict because only one user will be using the database. However, in case of Multi-User Applications, many users may be accessing the database through the same Form, at the same time, resulting in conflict of primary key; To tackle this problem, Kushal has AutoIncrementingMultiIndex which, when set to 'True', the Primary Key is checked again at the time of 'Save', and in meantime if the field has been already incremented, the next value is set, and a message is shown to the end user.