Shared facts -- finding who is sharing and under what role

I’m trying to remove a role from a fact, but RMG won’t let me do so, because the fact is in use. Is there a way to find which individuals are listed under a particular role?

I originally created the roles of “Son” and “Daughter” to share a fact, then later figured out how to simply create “Child” and let the database find gender. I would like to delete the “Son” and “Daughter” roles, but cannot determine who in my database has been assigned them.

There is no way to find the roles short of using an SQLite script. RM’s roles and shared facts are very hard to manage. You can’t search for them or make groups based on them or color code based on them or anything of that nature.

Well, the only thing that I can think of that might be possible would be to rename the roles to something like XXXXX and YYYYY instead of Son and Daughter. Then run an Individual Summary report for everybody in your database, save the report to a file, and edit the report file to look for the strings XXXXX and YYYYY. But that might be a huge report that would take hours to produce and edit if you have lots of people in your database.

Is 10,000 a lot?

: - )

You can generate a GEDCOM and then use any text editor to search for:

3 ROLE Son
3 ROLE Daughter

For each match you then scroll upwards line by line until you find the person it’s attached to:
1 NAME Patrick R /Doe/ <—sample name only

Now goto that person within RootsMagic and edit it away. Same for all others.


Got it. Took me about an hour to run them all down, but my list of Roles is much cleaner now.


Another easy method would be to edit the fact type roles and change both of the son and daughter roles to “child”. Yes, you would have duplicate roles in the fact type, but RM8 apparently doesn’t seem to care. Keep in mind that census records rarely listed a role as “child”. but I understand your preference.

That’s a very clever solution. I like it. There are probably many other hard to find problems that are amenable to being solved in the same way.