Kathy: Any database, or any search tool that might be invented for use with a database that I can imagine, would depend on your entering things in an accurate and consistent manner.
“Brechinn angus” will be understood by a database as one specific entry. “Angus” will be understood by a database as an entirely unrelated entry. And “Angus Scotland” will be understood as yet a third completely unrelated entry. That’s just the way most all databases work. No database can read your mind – it will search for identical things that you tell it to search. If you want to use search and global features, I believe you may have to redo each entry into a consistent format. From: Kathy Thompson [mailto:[email protected]] Sent: Sunday, November 10, 2013 8:17 PM To: [email protected] Subject: Re: [LegacyUG] Search for all people in one county I do understand that Bruce, but when I first started I would simply put in (as examples) Angus Brechin angus (complete with no capital and no comma) Angus Scotland (again, complete with no comma) so you see, I can't very well sort like the program can do because Angus isn't going to come up in the first position if there are no commas there Hence I need a search feature to help me find all of these stray locations so that I can actually get things organised and standardised. On 11 November 2013 14:06, Bruce Jones <[email protected]> wrote: Kathy, When they say to "standardize" your location, it doesn't mean they have to have a specific number of positions, just that they need to be entered in a consistent manner; i.e. either from smallest to largest or from largest to smallest, regardless of the number of positions. So, If you have locations entered as follows: Sublimity, Marion, Oregon, USA Marion, Oregon, USA Oregon, USA Salem, Marion, Oregon, USA 123 Anystreet, Sublimity, Marion, Oregon, USA they are consistently entered from smallest to largest. Then, go to "View", "Master Lists", "Location" Click on "Sort" Click on "Right to Left" on Direction of Sort Then they will be listed as USA, Oregon USA, Oregon, Marion USA, Oregon, Marion, Salem USA, Oregon, Marion, Sublimity USA, Oregon, Marion, Sublimity, 123 Anystreet So, all the Oregons will be together, all the Marions will be together, all the Sublimitys will be together etc. This may or may not help you, but I wanted to make sure you understood what is being said <snip> 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
