Yes, it is the identical source where our genealogy book has been used. My cousin used NAME for everything when I intended for her to use UNSPECIFIED. I'm just very big on consistency and I don't want the thousands that have already been done to be different from the thousands yet to do. Does that give you enough information? I looked at your ITools a bit (I'm a registered user), but I didn't readily see anything that would help, but perhaps I overlooked it. Thanks, --Jerry / http://www.MerriamFamilyTree.org
On 8/17/2011 5:47 PM, Dennis M. Kowallek wrote: > On Wed, 17 Aug 2011 17:19:54 -0400, Jerry<[email protected]> > wrote: > >> Hello again. Is anyone aware of any shortcut keys (other than the >> source clipboard) that might help me out with my project? What I wish >> to do is to transfer a source that was input under NAME to the >> UNSPECIFIED source item. for over a thousand records. I'm doing this >> for consistency and because I don't want to populate multiple sources >> which would increase our website bandwidth until there are new sources >> to add to the individual fields. There is detail to go with each source >> record (page numbers from our large book), so I can't just change >> everything over without cutting and pasting the detail. I'm plugging >> along fairly fast, but just wondering if anyone knows of an even more >> stream-lined approach. > Sounds like a perfect project for a little SQL. > > UPDATE tblSX SET tblSX.Type = 0 WHERE ((tblSX.Type = 1) AND ([some other > stuff to narrow things down a bit])) > > You'd need to be more specific for me to say more. Is it one particular > Master Source for which EVERY occurrence pointing to NAME needs to be > changed to point to UNSPECIFIED? > > Use MS Access or another tool (hint) to perform the query. > 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://www.LegacyFamilyTree.com/Help.asp 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
