Please or Register to create posts and topics.

Update Group of people based on master source #namedgroup

I often want to group people citing a master source (to color or work on them without using static lists).

For example I want to see who use my 'National Archive' master source. For that I create a group 'Sourced_NationalArchive' (with a random person) and use theGroup_MasterSource.sql (below) to update that group.

To update another group 'Sourced_NationalArchive_DeathFact' with people using 'National Archive' master source but in death fact specifically, I use  Group_MasterSource_Fact.sql.

Finally, for another group 'Sourced_NationalArchive_Birth' using the same master source 'National Archive' but only having the word birth used in  reference 

I use Group_MasterSource_Reference.sql to update that group.

There is another method here:

Uploaded files: