For a dataelement having optionset, during entering the data, if we select an option and save it, later if we remove the value for it, it shows null value in the database. Thus displays a sync issue when we are syncing the data from Field server to the central server.
Ideally it should remove the entire row in the Database if the option value is removed.
Do you save and sync then delete or save, delete and then sync?
There’s a step that you might want to consider after deletions which is Data Administration > Maintenance. For example, the option “Permanently remove soft deleted data values”.