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. -- Dennis Kowallek (LTools) http://zippersoftware.com/ltools/index.htm http://groups.yahoo.com/group/ltools NOTE TO LUG USERS: Use plain text if you want me to read your post. 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
