Thanks Tom and Jerry,
Ok, I apologize for that, I couldn't resist the Disney connection.
Tom your points are well taken and I will do a lot of testing before attempting to modify real projects. One thing, it has been awhile since I worked extensively with SQL, should I do an insert from my FactType database first and then the update, vice versa, or is there a combined way to do both?
Jerry I completely missed that fact that if I customize an individual fact for a person the it will need to be stored somewhere else. I am working to get rid of all such individual modifications.
TMG was a very powerful product when it comes to output. TMG had some other things that I wish products like RM and GEDCOM would adopt. Topic for another time. When you say tightly coupled do you mean that I can customize a sentence and actually hard code a person's name in the sentence? That never entered my mind as I want all sentences to be generic for anyone in my database and I use fields like Date, Place, PlaceDetails, Description and Notes to make any sentence output unique to a fact/event so sentence structures take a bit more thought to get them to work with anyone in any situation. My sentences will not win any literary awards but at least it will easier to read/ I would want my sentences to work with all your data as well. I'm sure that my sentences would not meet your goals but at least I would get reasonable output.
One further complaint about RM. All my notes are rendered outside of any footnote and therefore are not sourced. It would be great if RM provided a way to include the notes as part of the fact or use notes as an un-sourced piece of information. Again a topic for another time.