Connecting picture to person

Our genealogy database program.

Moderator: Nick Hunter

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

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?

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

Re: Connecting picture to person

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


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:

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:

Post Reply