Great idea!!!
From: LegacyUserGroup <legacyusergroup-boun...@legacyusers.com> On Behalf Of CE WOOD Sent: Monday, July 23, 2018 10:01 AM To: Legacy User Group <legacyusergroup@legacyusers.com> Subject: Re: [LegacyUG] Address Information Your plethora of "St. Church" locations is easily solved by putting the Town first - "Bamburgh Church of St. Mary" or "Bamburgh St. Mary's Church". That also keeps report indices sorted by town. CE _____ From: LegacyUserGroup <legacyusergroup-boun...@legacyusers.com <mailto:legacyusergroup-boun...@legacyusers.com> > on behalf of Chris Hill <chris.hill.11he...@gmail.com <mailto:chris.hill.11he...@gmail.com> > Sent: Monday, July 23, 2018 4:26 AM To: Legacy User Group Subject: Re: [LegacyUG] Address Information Hi Cathy That was pretty well what I had suspected. It almost seems that the developers only built half of the system with dealing with locations/places vs addresses, or just added addresses as a later extension. I started using the locations to locate a physical area such as a Village or Town / / County / Country (being UK based and based on the GeoLocation list), with occasional extensions to add further sub-units, such as Hatcham, New Cross, , Surrey, England where Hatcham, Surrey would be misleading. I then started finding references to churches, as in baptisms and marriages, and started adding those to the location list, and my current locations list is around 2500 entries, of which 200 or so start with St church / location. I rather suspect that this is what most users do. But this started to become more complex, especially as those entries were included in the Location index in reports at the building level. So I then started looking at the Address fields, which happily show up as an icon on the marriage and events, or as Address.. option against birth, baptism, death and buried entries. Now, as I am working through my database, I am moving all of the entries in Location that refer to a building, or vessel, into the Address entries, where I can be specific to the building or church by street and location. Currently I have nearly 500 churches, or equivalent, and more than 100 other addresses. The reverse is that I have removed many of those from the Locations list since they map to a single location. My feeling is that I am working the 'right' way to record Addresses as being different from Locations. but that the system, while supporting both, does not have sufficient support for addresses or integration between addresses and locations. Regards Chris ------ Original Message ------ From: "Cathy Pinner" <genea...@gmail.com <mailto:genea...@gmail.com> > To: "Legacy User Group" <legacyusergroup@legacyusers.com <mailto:legacyusergroup@legacyusers.com> > Sent: 23/07/2018 03:28:57 Subject: Re: [LegacyUG] Address Information Chris, Searching on Marriage Address isn't available. I think the only thing you can do is work from the Master List for Event Addresses (View - Master Lists - Addresses - Event) and the Show List options there. OR, as you say, go direct to the Access database and use SQL since you appear to know how. So long as you make a backup before you do this, you can always recover if you don't get it right. Put in a suggestion to include Addresses in the Search options for Marriage. ;) I don't use Event Addresses in Legacy. The tools for Locations are far better. Because I don't use them, I rarely think of asking for them to be improved. I leave that to those that do use them. Nothing I do depends on keeping to the artificial 4 location field idea (which works for most USA locations but not for those in Australia or England where the majority of my research is) so I enter locations from smallest unit to country and sort the location list right to left. Cathy Chris Hill <mailto:chris.hill.11he...@gmail.com> Sunday, 22 July 2018 11:29 PM Hi Jenny No, that does not work and gives very odd responses. The problem is that I need to look at the Addresses with the small house icon and not at the Place of the event or marriage. Regards Chris Jenny M Benson <mailto:ge...@cedarbank.me.uk> Sunday, 22 July 2018 10:23 PM I don't think I'm quite sure exactly what you want to search for, but will searching for a Marriage with Marriage Place empty AND a secondary condition of Marriage with Marriage Event-Place not empty do what you need? Chris Hill <mailto:chris.hill.11he...@gmail.com> Sunday, 22 July 2018 9:47 PM Where necessary, usually for baptism, death and marriages, I normally place the location of the church etc. into the corresponding fields in the individual or the marriage, and for marriages I also place them into events for marriage banns and witnesses. This then means that if I enable it in the reports I will get the (address text) in the report, which I can control as required. My problem is that I have found that I may have missed putting the addresses on marriage itself, but have put them on the marriage events. What I cannot find is a search or report that will identify this condition, and not even one that will list the addresses listed on the marriages and their events so that I can locate those that I need to fix, and I have 3500 marriages in my database. I could probably fix it will a single SQL statement against the database, but don't really want to try that. Regards Chris -- LegacyUserGroup mailing list LegacyUserGroup@legacyusers.com <mailto:LegacyUserGroup@legacyusers.com> To manage your subscription and unsubscribe http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com Archives at: http://www.mail-archive.com/legacyusergroup@legacyusers.com/
-- LegacyUserGroup mailing list LegacyUserGroup@legacyusers.com To manage your subscription and unsubscribe http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com Archives at: http://www.mail-archive.com/legacyusergroup@legacyusers.com/
