Rob, I may have unintentionally misled you.
The user defined bit I was referring to is simply a prefix that I put in front of my Ahnentafel numbers. I put a B_ in front of my lot and a J_ in front of my wifes lot. This lets me quickly know where I am if I am deep in the ancestral part of the tree. Although I havent done it, I believe that you could also put an extra digit in front ie the prefix could be B_9 or B_99 etc. I have not got any raw SQL code for placing an absolutely unique integer as a user defined number. The chap who wrote Ltools may be able to help you with a custom sql query if you contact him it would probably be a tweak of the sql he has already written and wouldnt be expensive. Hope this helps and apologies if I got you too excited. Bill On Mon, Feb 15, 2010 at 9:41 PM, RUNION ROBERT <[email protected]> wrote: > Bill - Would you share the coding you use to assign a 'user defined number' > (in detail please)? > > Bob > > On Feb 15, 2010, at 2:14 AM, Bill Wood wrote: > >> Hello, >> >> Ltools is a useful little program that gives you a degree of >> automation and simplicity in assigning user defined numbers to people >> in a Legacy File. >> >> I have used it and saved myself a lot of time with AHnentafel numbers >> and it also has automatic processes for Henry numbers. >> >> Ltools is here zippersoftware.com/ltools/index.htm >> >> >> >> Bill >> >> On Mon, Feb 15, 2010 at 3:21 AM, William Dukstein <[email protected]> >> wrote: >>> I just received a Legacy database from a distant cousin. In order to more >>> easily compare my database and this new one, I would like to re-designate >>> all of the Henry numbers in this new file. In my file I am listed as #1. >>> In the new file, I am listed as #12345. How can I change my designated >>> number to #1 in the new file and have Legacy re-designate all of the other >>> individuals according to the numbering system. This way I would be able to >>> cross check individual #40 in both files to see if the information agrees. >>> Make sense? Any advise would be greatly appreciated. >>> >>> Bill >>> >>> >>> 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 >>> 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 >> >> 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 > > 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 To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
