Connecting picture to person

Our genealogy database program.

Moderator: Nick Hunter

Post Reply
sdj
Posts: 12
Joined: Wed May 13, 2009 11:23 am
Location: United Kingdom
Contact:

Connecting picture to person

Post by sdj » Fri Jun 15, 2012 2:15 pm

I have 2 pictures in the Picture Folder and do not know which person or family they belong to. I have 344 people and 110 families in this database and have checked the likeliest ones. Is there a way of listing pictures and the person they are connected to?
Thanks

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

Re: Connecting picture to person

Post by Nick Hunter » Fri Jun 15, 2012 3:34 pm

Hi,

Yes. Please use "Search | Search" or click on the "Search" button on the toolbar. Then click on the "SQL query" tab at the top.

In the "SQL query" box, to simply list all pictures which the database knows about, use:

SELECT *
FROM Pictures

and click on the "Search" button. You can open the appropriate person/family and the picture by double-clicking in the results list at the bottom.

If you want to look at pictures linked to only people and also include the person's details, use:

SELECT Pictures.Filename, Pictures.Description, People.Description Person
FROM Pictures, People
WHERE Pictures.RecordType = 'P' AND Pictures.RecordCode = People.Code


This page in the manual explains how to use the Search feature in K&KPro:
http://kithkinpro.spansoft.org/manual/html/query.php

Post Reply