I have approx 2 million names from the South African voters list where I would like to link the wives to the husbands. The wife and husband will have the same address under General notes, but the wife will be shown married to say PN Smith and now I would like to find the Smith with the same address. I could do it one by one, i.e. type in die wife's adress and then under search and replace find the same adress and when it is the wife's skip it untill the husband's come up. This obviously will take me ages. Is there a way to automate this process? Maybe with SQLite?
I installed RootsMagic 6 via Parallels Desktop on my MAC and when I do a "duplicate search" and then wants to "merge two people" I get the error: SQLite error 5 - database is locked. This did not happen in RM 5. Any idea how I can resolve this?