Over time I have managed to have several Source Document & Repository duplicates and wish to keep only one.
However, I am a little nervous to do so as I fear that I may remove relevant data. Is the code reference purely a reference or not? I've looked through the help files and whilst they discuss adding sources etc do not appear to give any guidance to remove.
Regards
Peter
Editing Resources etc
Moderator: Nick Hunter
-
- Posts: 45
- Joined: Thu Apr 06, 2006 7:19 pm
- Location: UK
- Contact:
-
- Posts: 669
- Joined: Sun Dec 18, 2005 9:36 am
- Location: SpanSoft, Scotland
- Contact:
Hi,
If you delete a source document which is referenced by a source in a person or family data form, the source will remain intact but will no longer point at any document.
Before deleting any source documents, it might be wise to run the following SQL query in the Search window:
SELECT *
FROM Sources
ORDER BY Document
Then check if any of these sources are referring to the document (using the code) which you intend to delete.
Similarly check for references between source documents and repositories.
If you delete a source document which is referenced by a source in a person or family data form, the source will remain intact but will no longer point at any document.
Before deleting any source documents, it might be wise to run the following SQL query in the Search window:
SELECT *
FROM Sources
ORDER BY Document
Then check if any of these sources are referring to the document (using the code) which you intend to delete.
Similarly check for references between source documents and repositories.