Open JoshCWK opened 7 years ago
It is being caused by the insurance details in workerInsurans table which not being removed together when the associate record in workerDetails table has been removed for re-enter purpose. This has lead to double entry in workerInsurans table when the particular foreign worker detail has been re-enter again.
The workaround is create a function that check the existence of insurance detail in workerInsurans table before insert the particular worker detail.
For the earlier bug of duplicate foreign worker records display in record preview page has been resolve. [Finishes #134910847]