Interesting. Sounds as if you have the dangers of editing the database direct in Access covered.
It would probably have been as quick to exclude them as to tag them unless you haven't researched each person. And if you haven't researched each person, why not just turn that criteria off in the PP settings? One day I must learn how to use SQL but I've never felt enough need for it to make the effort worthwhile. Cathy Jay Wilpolt wrote: > > 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] > <mailto:[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]> >> <mailto:[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> >> <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]> >> <mailto:[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 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
