Kith and Kin Pro manual

Kith and Kin Pro site SpanSoft main site

Kith and Kin Pro

Getting started

Introducing Kith and Kin Pro

Converting from older versions of Kith and Kin

Using Kith and KinPro with TreeDraw

Tutorials

Tutorial - Using the Tree Area

Tutorial - Working with person and family data forms

Tutorial - Simple searching

Tutorial - Searching using queries

Tutorial - Printing

Tutorial - Adding extra fields to people and families

Tutorial - Starting your own family tree

Tutorial - Importing a GEDCOM file

Tasks

Database maintenance

Starting a new database

Creating a clean database

Opening an existing database

Saving a database

Merging two databases

Copying a database

Copying part of a database

Changing the name of a database

Packing a database

Repairing a database

Clearing a database

Deleting a database

Adding and maintaining user-defined fields

Backing-up your data

Restoring data from a backup

Data maintenance

Adding a new family

Adding a new person

Editing an existing family

Editing an existing person

Marking probable links

Adding and maintaining aliases

Editing notes

Organising notes

Entering dates

Working with pictures

Working with objects

Adding and maintaining sources

Deleting a family

Deleting a person

Adding and maintaining source documents

Adding and maintaining source document repositories

Updating descriptions

Re-using an old person or family code

Updating death flags

Removing duplicate records

Editing data in bulk

Searching / querying

Searching for people

Seaching for families

Searching for sources

Using a query to find data

Calculating ages

Calculating phonetic codes

Displaying statistics

Displaying a relationship between two people

Searching for date errors / inconsistencies

Searching for events on a particular day

Searching for people who are not on the Tree Area

Displaying modified records

Screen

Moving around the Tree Area

Zooming in and out

Moving to a specific family

Selecting families using the mouse

Selecting families by relationship

Selecting all families

Moving families

Displaying a family summary

Arranging the open forms

Closing all open forms at once

Aligning families vertically

Using the Timeline Window

Choosing layers

Choosing the selection's layer

Choosing all layers

Moving families to a layer

Removing families from a layer

Creating a new layer from selection

Managing layers

Choosing fonts and colours

Turning the Tree Area on and off

Turning the Button Bar on and off

Turning the Status Bar on and off

Turning the Tree Area Control on and off

Printing

Using the report control form

Printing the tree layout

Printing family details

Printing person details

Printing indices

Printing a descendant tree

Printing an ancestral tree

Printing an indented descendant tree

Printing a missing data report

Printing a timeline

Printing a census report

Printing source document details

Printing document repository details

Setting printer options

Setting page options

Previewing a report on the screen

Printing from a preview

Printing to text files

Copying printed pages to the clipboard

Importing / exporting

Importing a GEDCOM file

Exporting a GEDCOM file

Exporting Web pages

Customising Web pages

Exporting data to a delimited text file

Importing a text file into notes

Exporting a text file from notes

Exporting a report to a PDF file

General

Setting preferences

Editing the timeline

Customising the button bar

Setting date options

Converting dates

Setting options

Setting current database options

Choosing a family to move to when the tree is opened

Choosing the current database language

Setting regional / language options

Setting picture options

Exiting from the program

Checking for program updates

Reference

File menu

Edit menu

Search menu

View menu

Layers menu

Tools menu

Window menu

Options menu

Using the Tree Area Control

Selecting / defining a database name

Selecting a family

Selecting a person

Database fields

Additional LDS information

SQL syntax

Supported GEDCOM syntax

Timeline text file format

System requirements

Frequently asked questions

Version information

Terms of use

Glossary

GEDCOM

Layer

LDS

Metaphone

OLE embedding

OLE linking

OLE object

Soundex

Tree Area

How to get support

How to contact us

Ordering / registration

Database fields

Kith and Kin Pro stores family tree data in a relational database. This consists of several separate tables (files) within the database folder which are linked together by common fields. To understand how to create custom SQL queries you need to know what the available database tables and fields are and how they are linked together.

Field types

Table nameField nameType Links / Notes
Aliases PersonCodeIntegerPeople | Code
Date of changeDate 
SurnameString (60) 
FirstnamesString (60) 
SoundexString (4)Soundex code for the surname
MetaphoneString (10)Metaphone code for the surname
DocumentsCodeInteger 
TitleString (60) 
AuthorString (60) 
PublicationMulti-line 
RepositoryIntegerRepositories | Code
Repositorys refString (60) 
MediaString (60) 
NotesMulti-line 
FamiliesCodeInteger 
DescriptionString (120) 
Marriage dateDate 
Marriage placeString (60) 
Divorce dateDate 
Divorce placeString (60) 
Fathers nameString (60)Surname first for sorting
Mothers nameString (60)Surname first for sorting
Change dateDateDate of last record change
ChangedLogicalRecord changed flag
LayerIntegerLayers | Code
(user-defined fields)  
LayersCodeInteger 
DescriptionString (60)Layer name
LinksRecTypeString (1) 
PersFamIntegerPeople | Code if RecType = 'P';
Families | Code if RecType = 'F'
ChildMarrIntegerFamilies | Code if RecType = 'P';
People | Code if RecType = 'F'
OrderDecimal 
DefiniteLogicalFalse = probable link
NotesRecordTypeString (1) 
RecordCodeIntegerPeople | Code if RecordType = 'P';
Families | Code if RecordType = 'F'
CodeInteger 
DescriptionString (60) 
PrivacyLevelSmall integer 
NotesMulti-line 
ObjectsRecordTypeString (1) 
RecordCodeIntegerPeople | Code if RecordType = 'P';
Families | Code if RecordType = 'F'
CodeInteger 
OrderIntegerSequence number to define the order
DescriptionString (60) 
PeopleCodeInteger 
DescriptionString (120) 
SurnameString (60) 
FirstnamesString (60) 
MaleLogicalTrue = male
Birth dateDate 
Birth placeString (60) 
Christening dateDate 
Christening placeString (60) 
Death dateDate 
Death placeString (60) 
Burial dateDate 
Burial placeString (60) 
Search dateDateBirth or christening date for sorting
Search placeString (60)Birth or christening place for sorting
DeadLogicalTrue = dead
Change dateDateDate of last record change
ChangedLogicalRecord changed flag
SoundexString (4)Soundex code for the surname
MetaphoneString (10)Metaphone code for the surname
(user-defined fields)  
PicturesRecordTypeString (1) 
RecordCodeInteger People | Code if RecordType = 'P'
Families | Code if RecordType = 'F'
Documents | Code if RecordType = 'D'
Sources | Order if RecordType = 'S'
CodeInteger 
OrderIntegerSequence number to define the order
InPrintsLogicalTrue = include in printouts
DescriptionString (60) 
FilenameString (60)Image filename relative to the Pictures folder
WidthSmall integerin tenths mm
HeightSmall integerin tenths mm
PLayers  Identifies the layers each person is on
PersonCodeIntegerPeople | Code
LayerCodeIntegerLayer | Code
RepositoriesCodeInteger 
NameString (60) 
AddressMulti-line 
PhoneString (20) 
EmailString (60) 
Web siteString (60) 
NotesMulti-line 
SourcesOrderIntegerSequence number to define the order
RecordTypeString (1) 
RecordCodeIntegerPeople | Code if RecordType = 'P';
Families | Code if RecordType = 'F
FieldNameString (30) 
DocumentIntegerDocuments | Code
PageString (60) 
QuaySmall integerQuality of data; 0=Primary evidence - 3=Unreliable
NotesMulti-line 
UFields  Holds the definitions for user-defined fields
RecTypeString (1)People table if = 'P';
Families table if = 'F'
FieldNameString (25) 
GEDTag1String (5) 
GEDTag2String (5) 
GEDTag3String (5) 
PrivacyLevelSmall integer 

See also