Editing Resources etc

Our genealogy database program.

Moderator: Nick Hunter

Post Reply
Peter Rawbone
Posts: 45
Joined: Thu Apr 06, 2006 7:19 pm
Location: UK
Contact:

Editing Resources etc

Post by Peter Rawbone » Wed Mar 10, 2010 7:06 pm

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

Nick Hunter
Posts: 669
Joined: Sun Dec 18, 2005 9:36 am
Location: SpanSoft, Scotland
Contact:

Post by Nick Hunter » Wed Mar 10, 2010 8:24 pm

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.

Post Reply