I reccomend yo use 10001 instead of 10000. It should be obvious why.Rich in LA CA
--- On Mon, 12/26/11, Robert57P_gmail <[email protected]> wrote: From: Robert57P_gmail <[email protected]> Subject: [LegacyUG] RIN renumbering To: [email protected] Date: Monday, December 26, 2011, 5:37 PM I have 2 Legacy files I want to merge. To more easily identify which record came from which file (while I do the importing/merging), I'd like to renumber one of the files. File 1 = RIN 1 through 307 File 2 = RIN 1 through 1623 I'd prefer to renumber all RINs (and MRINs) in file 2 so that 10,000 is added to each existing RIN number. Thus: 1 would now be 10001 45 would now be 10045 1623 would now be 11623 This way I can tell, at a glance, what the original RIN was in case I need to go back to the original file for some research/comparison/etc. For example, if I see a RIN of 10540, I know it came from file 2 and was originally 540. I know I can renumber them one at a time via TOOLS/RENUMBER RINS, but is there a better way to do this renumbering? Either within Legacy or via some 3rd party tool? I see a renumber option in the IMPORT dialogue box, but it looks like it would not keep any relationship between the original RIN and the new RIN. (I'd prefer to not export them to MS Access - I've tried going the Access route in the past and always seem to have some kind of problem). I believe another option would be to make all USER IDs equal to "FILE 2 [RIN]" in file 2, but I have a feeling in my gut that it would be better to deal with the RIN field instead . . . Thanks, Bob 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 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
