Page 1 of 1
Connecting picture to person
Posted: 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?
Re: Connecting picture to person
Posted: 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:
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: