I see that you have added this to your LTools program from http://zippersoftware.com/ltools/download.html.
Now we can all be happy ;-) Ron Ferguson _____________________________________________________________________ Tutorials: Programme of adding videos commenced http://www.fergys.co.uk/ View the Grimshaw Family Tree at: http://www.fergys.co.uk/Grimshaw/ For The Fergusons of N.W. England See: http://myweb.tiscali.co.uk/fergys/ _____________________________________________________________________ ---------------------------------------- > From: kowal...@iglou.com > To: LegacyUserGroup@legacyfamilytree.com > Subject: Re: [LegacyUG] Index Sorting > Date: Tue, 4 Aug 2009 08:10:06 -0400 > > On Tue, 4 Aug 2009 09:14:02 +0100, ronald ferguson > wrote: > >>Index>Options allows sort by User ID > > Which gives me the idea of somehow mechanically populating the User ID > with the birthdate. ;-) > > I think the SQL would look something like: > > UPDATE tblIR INNER JOIN tblNX ON tblIR.IDIR=tblNX.IDIR SET > tblIR.UserRef=tblIR.BirthSD,tblNX.UserRef=tblIR.BirthSD > > You could use Access, OpenOffice (I think), or some other 3rd > party tool to run this query. > > -- > > Dennis Kowallek (LTools) > http://zippersoftware.com/ltools > http://groups.yahoo.com/group/ltools > _________________________________________________________________ Windows Live Messenger: Happy 10-Year Anniversary—get free winks and emoticons. http://clk.atdmt.com/UKM/go/157562755/direct/01/ Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
