Fact Types are defined within the FactTypeTable, one record for each type. Apart from the RecordID and Name, truly identical fact types would have all other fields exactly the same, too. So it should be possible to write a SQLite query that would identify such duplicates. However, there will likely be some subtle differences between any pair that look to be the same on the RM screens that the query will deliver negative results. OTOH, you probably know the names of the fact types you want to merge and are willing to ignore minor differences. A merge would involve selecting one fact type as primary and the other fact type to merge into the primary. The merge would merely replace in the EventTable the FactTypeId of those events having the secondary ID with the primary ID. Then, optionally, delete from the FactTypeTable the secondary facttype so it is not reused. On the Edit Person screen, there is a change fact type button, IIRC. That allows you to change the type of one fact at a time. Tom On 2012-06-07, at 3:06 PM, David <davenmesa@live.com> wrote: > Morning Tom, > #3 is the one I am interested in since that is the only one I have > problems with. > > David > > On 6/7/2012 11:09 AM, Tom Holden wrote: >> Do you mean to merge: >> 1. Identical facts for a person? >> 2. Identical facts across multiple persons? >> 3. Identical fact types? >> >> These are very different requirements with very different solutions. >> >> Tom >> >> >> >> On 2012-06-07, at 1:31 PM, David Bryant <davenmesa@live.com> wrote: >> >>> Since the folks at RootsMagic apparently have no real desire to provide us with a means of combining IDENTICAL facts (ie a RM default fact with a identical imported fact) I would like to know if any of you computer wizards know of (or have a program) that will combine a RM4 default fact with a identical customer imported fact. >>> >>> Any help will be greatly appreciated. >>> >>> David >>> >>> >>> =================================== >>> RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ >>> http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS >>> WISH LIST: http://www.rootsmagic.com/forums/ BLOG: http://blog.rootsmagic.com/ >>> >>> >>> ------------------------------- >>> To unsubscribe from the list, please send an email to ROOTSMAGIC-USERS-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message >> >> >> =================================== >> RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ >> http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS >> WISH LIST: http://www.rootsmagic.com/forums/ BLOG: http://blog.rootsmagic.com/ >> >> >> ------------------------------- >> To unsubscribe from the list, please send an email to ROOTSMAGIC-USERS-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message >> >> > > > > > =================================== > RM list Archives: http://archiver.rootsweb.com/th/index/ROOTSMAGIC-USERS/ > http://archiver.rootsweb.com/cgi-bin/search?path=ROOTSMAGIC-USERS > WISH LIST: http://www.rootsmagic.com/forums/ BLOG: http://blog.rootsmagic.com/ > > > ------------------------------- > To unsubscribe from the list, please send an email to ROOTSMAGIC-USERS-request@rootsweb.com with the word 'unsubscribe' without the quotes in the subject and the body of the message