Mike What I suggested was a master location record and a chain of location name records which are given a date range. (I don't know the Access terminology, but this should be clear, I hope)
The advantages of this are that it is easy to produce a report showing how the location name has changed over time and it has only one entry in the master location list. Under the current scheme, there can be lots of entries for one physical location and they don't all sort together in the list. This makes it confusing when trying to see who lived at a single location when that location can be all over the shop. I'm probably more affected than many, because I like to put all address information into the location, but this would still make life easier for anyone who has a place name change over the years. Cheers Tony 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
