Tom HoldenChange your cover photoUpload Change your cover photoUpload Tom Holden This user account status is Approved About About Posts Posts Comments Comments I've adapted my script referenced above and the OP has used it successfully. I may publish it after possibly generalising… On RESIDENCE conversion to CENSUS I just saw your comment here but your link to the RootsMagic Community topic on Resetting TreeShare has no comment… On Media – Set Primary Photo for Persons #media #update There are a couple of partial solutions: - a SQLite script by me published here: Facts – Change Fact Type… On RESIDENCE conversion to CENSUS Solved by @thejerrybryan in a post in the Forum: https://sqlitetoolsforrootsmagic.com/forum/topic/ctes-can-be-useful-in-update-queries/ On Weblinks in footnotes I've added an explanation of the basic script's processes at https://docs.google.com/document/d/1eXr0z8d2AFuswc2H6wLuUBB4DgOEwzgh8WfVFOmy9kc/edit?usp=sharing On RM-LineageLoopDetector.sql: Uncovering Lineage Loops in RootsMagic Databases Wow! What's the subject of your dissertation? I'm impressed that Gemini could ingest the whole spreadsheet. Thanks to @kevinm for… On Unlocking Your RootsMagic 10 Data: A Deep Dive into SQLite Queries (with AI) Still works with versions including RM10 On Places – Conversion of Place Details to Places #places #placedetails #update A "No loop detected" result has been added to the latest version which now operates on a group of people,… On RM-LineageLoopDetector.sql: Uncovering Lineage Loops in RootsMagic Databases I rarely use the SQLite CLI and did not realize how bare no results from a query can be. The… On RM-LineageLoopDetector.sql: Uncovering Lineage Loops in RootsMagic Databases From my 2010 query for database properties: SELECT '- System Places', COUNT(1), 'system supplied Places: LDS Temples' FROM PlaceTable WHERE… On Unlocking Your RootsMagic 10 Data: A Deep Dive into SQLite Queries (with AI) load more comments