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:[email protected]>
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:[email protected]>
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:[email protected]>
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
[email protected]
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/[email protected]/

Reply via email to