Cathy, Thanks for the info. My inquiry was needed because I plan to use SQL to update about 570 records for persons to be excluded on one particular item (born before parents marriage)
So I have the records tagged with Tag5. So my sql will search for persons with a tag5 and Set the field of PPCheck to be 1 and Set the PPExclude to be H (which is what is in that field for records that already have the exclude from pot probs set.) I always test any changes on a test copy of my database, and I always run a File check before I start adding information. Is there anything else I need to be aware of? Thanks, Jay On Sat, Nov 7, 2015 at 6:34 PM, Cathy Pinner <[email protected]> wrote: > Hi Jay, > > There are columns on more than one table for PPcheck and PPexclude. > Why do you want to know? > > If you want to see who has exclusions from within Legacy, you can run a PP > report only for those people who have exclusions. > > If you want to see on Family View that there are exclusions, check Options > - Customise 8.11 > If you want to see what issue has been flagged for exclusion for a person, > see their Individual Screen. If they're excluded, the Excluded from > Potential Problems button has an asterisk > Click it and you can see which category has been excluded for that person. > > Cathy > > Jay Wilpolt wrote: > > > Margaret, > > Thanks for that info. > > I see that the PPCheck column (in tbl.IR) is used, but then how does > it know WHICH Potential problem to ignore... > > Jay > > > > On S at, Nov 7, 2015 at 5:00 PM, Margaret Turner <[email protected] > <mailto:[email protected]>> wrote: > > PPExclude > > http://zippersoftware.com/wp/ltools/legacys-database/legacy-tables/?tableName=tblIR&tableDesc=Individual-Records > < > http://zippersoftware.com/wp/ltools/legacys-database/legacy-tables/?tableName=tblIR&tableDesc=Individual-Records > > > :) > Margaret > > On 8 November 2015 at 11:06, Jay Wilpolt <[email protected] > <mailto:[email protected]>> wrote: > > Fellow Legacy Users > > Where in the database table does the Flag get set when I set a > person to be exluded from Potential problems item (in this > case when a person is born before a parents marriage date.) > > I do not see any field in the tbl.IR (persons) table > > Thanks in advance for any help > > Jay > > > > Legacy User Group guidelines: > http://www.LegacyFamilyTree.com/Etiquette.asp > Archived messages after Nov. 21 2009: > http://www.mail-archive.com/[email protected]/ > Archived messages from old mail server - before Nov. 21 2009: > http://www.mail-archive.com/[email protected]/ > Online technical support: http://support.legacyfamilytree.com > Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and > on our blog (http://news.LegacyFamilyTree.com). > To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Online technical support: http://support.legacyfamilytree.com Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
