JCK74656

I had a reply to this perceived problem over on Facebook so it is not broken, just smarter than a simple replace. This utility will not simply offer you a list of places without a Country if you enter "China" for example. The utility will only present places in your place list that it believes may be part of China.

I just wanted to say I have very much enjoyed reading the different styles and perspectives on this post, it will improve how I record data.

I always uncheck birth and death places, accurate places can be of great benefit but any slight difference can be a curse, wish it used the geocoding.

I am running the code kindly uploaded by Jerry Bryan pretty much as is with slight alteration to the Name Combine structure as below;

CASE
       WHEN Father.FatherID = 0 THEN Mother.Given || ' [' || Mother.MotherId || ']'
       WHEN Mother.MotherID = 0 THEN Father.Given || ' [' || Father.FatherID || ']'
       ELSE Father.Given || ' [' || Father.FatherID || '] ' || ' & ' || Mother.Given || ' ' || Mother.Surname
       END CombinedNames,

It is proving extremely useful in finding family matches and again I am confused why Rootsmagic do not include this for people tab. I don't know the company history but did read they were responsive to user needs, I am now wondering if anyone there does serious data comparison in research and if not am I some sort of nerd wanting this grouping on people tab?

 

Probably be easier to delete your test database and start over. Before you run the script, create the Parent fact with the Description field enabled and create a Birth_of_Child role. Then, run the script again in your test database.

 

Jerry

This worked but with Parents fact (plural), thank you.

I changed name combinations to display father given and mother birth given and surname, it's helping me to associate lots of families.