Duplicates can be caused by low connectivity when uploading records. The way the devices work is when a record is sent from the device, the server sends back saying it got the record. If the record sends a record, and never hears from the server, the device will think the record never got uploaded and will stay on the device. So when you upload records again, it will send the same record again thinking it never got sent up. It is better to get duplicates of a record, rather than having records become lost.
Duplicates in subform records can happen too because the mechanism is that the parent record will be uploaded first followed by the subform records and if the response time is too long subform records can be duplicated too. The bottom line for us is not to let you lose any data.
I understand the reasons for the issue (i.e. ensuring the data is there, rather than not), but I would propose an improvement that checks for duplicates upon upload, and removes them / doesn't write them to the database if indeed they are a duplicate? It can cause equal issues having the data duplicated than it can having it not there at all.
Please sign in to leave a comment.