Mike Fry, I suggest playing with LTools and a COPY of the Sample.fdb file. Generate a twin with your required name order. Then use LTools to change table IR so that the entry for BirthSD (birth sort date) is earlier for the first born by a day, but leave the entry for BirthD to be identical for both twins. See if this fixes the name order for the twins in reports and Legacy tables to reverse the name order as you want. Finally see if Legacy’s file check/repair features complain or reset BirthSD. It is not trivial to learn to use LTools, but it provides a way to deal with situations such as the one you describe.
From: Ron Taylor Sent: Wednesday, August 13, 2014 8:53 PM To: legacyusergroup@LegacyUsers.com Subject: Re: [LegacyUG] Maintaining Sequence of Twins/Triplets If all the children connected to a marriage have birthdates, then the children sort could easily be done by birthdate, sibling order, given name. If the children have been manually ordered, the children should stay in the set order. If the order has not been set, then child sort would be like it is in the current version (as if order = 0 for all siblings). This SQL illustrates this sort for children of a specific MRIN where all children have a birthdate. The WHERE clause specifies the MRIN of the parents to use. SELECT tblCR.IDIR, tblIR.BirthSD, tblCR.Order, tblCS.ChildStatus, tblIR.GivenName, tblIR.Surname, tblCR.IDMR, tblMR.HusbGivenName, tblMR.HusbMarrSurname, tblMR.WifeGivenName, tblMR.WifeSurname FROM ((tblCR INNER JOIN tblIR ON tblCR.IDIR = tblIR.IDIR) INNER JOIN tblMR ON tblCR.IDMR = tblMR.IDMR) INNER JOIN tblCS ON tblCR.IDCS = tblCS.IDCS WHERE (((tblCR.IDMR)=1)) ORDER BY tblIR.BirthSD, tblCR.Order, tblIR.GivenName; If any child does not have a birthdate in the database, then the children should be sorted by order, given name or the children with birthdates could be displayed in date order followed by the children without birthdates. They would need to be manually ordered or the birthdates could be set to "Abt" dates so that a later sort will order them. When the sort children by birthdate, order, given name or just by order, given name is complete, the order numbers can be re-assigned. The same logic would apply in the new tool for sorting all children in the database or a single family in Children Settings. On Wednesday, August 13, 2014 7:25 PM, Cathy Pinner <genea...@gmail.com> wrote: Hi Sherry, I suspect that you're not a twin nor a sister to a twin. I think your "usually" relates to people who are not closely connected to twins. I have older twin sisters born only half an hour apart. I've always known who the eldest one is - and the order is not the alpha order. There are also a number of sets of twins amongst my cousins - and again I know which one is the eldest in most cases. Fortunately I don't global sort very often - probably never again as I don't import files these days. I don't know a way to stop them reverting to alpha order on a global sort. Cathy Sherry/Support wrote: > Is it that critical that the first-born twin be listed first? Usually > people only consider the date, not the time. > > You could make an Event showing which twin was born first and include > the time of birth or put it in their Birth Notes. > > It looks like the twins sort in alpha order as a sub-sort. I have > several sets in my line and when I sort, they're always i n that order. > > We do have a suggestion listed to be able to include time with the > date but I don't know if this is something the programmers will be > able to implement or not. Honestly, this is such a rare request.... > You're the second person on the suggestion list..... > > Sincerely, > Sherry > Technical Support > Legacy Family Tree > > > On Wed, Aug 13, 2014 at 8:18 AM, MikeFry < > ​​ > emjay...@gmail.com <mailto:emjay...@gmail.com>> wrote: > > On 13 Aug 2014 15:30, Sherry/Support wrote: > > > You can manually sort the children in the Edit Children window > (right click on a > > child and select "Children's Settings". > > Yes! But if the file ever gets sorted again, the sequence gets > messed up. > > -- > Regards, > Mike Fry (Jhb) --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ 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/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ 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/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ 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
