I have a prototype application with sub forms and have 6 users. I am testing the scenario of intermittent / offline data sync scenario. I have a field called product # which is key value having initial value set to MAX(Data Capture[Product # / # de produit])+1 logic.
For testing I opened 2 browsers and turned off the wifi. Added a new record using both the browsers. In this case, both have the product # as 1. I save the records and turn wifi back on, I notice only the one of the record is saved in the back-end. But application show their respective data on the front end. That means, browser 1 showed the data added by browser 1 itself and same for browser 2. Backend had data for only browser 2.
Ideally, i would like all the data being added for both the user and is also visible for everyone. Any suggestions how to achieve this?
Hope to find an answer for this