Thanks Lorna. you were almost right but I needed to include just those who had a spouse with a custom ID and i did that by using INDI.~SPOU>REFN.
Works very well but i think i could improve it more.
As I said earlier each descendent of The Electress has a Custom ID so when I now run the query it shows me all the descendents who have married another descendent .....But each marriage is listed twice. for example I have a line showing Elizabeth II marrying Philip Mountbatten but also a line showing Philip Mountbatten Marrying Elizabeth II. It would be nice if I could just have one line per marriage.
I'm guessing what I need to do is exclude a person if they have already been listed as a spouse in the query but I'm not sure if that is possible . any ideas?
Sorry Tatewise I was typing my reply when you posted yours
One way is to exclude all Female descendants, then only the Male married Female entries will appear: Exclude if INDI.SEX matches Female
Another approach would have been to use a Family Query instead of an Individual Query. You may not have been aware that there are 9 Query Types; one for each Record Type - see the General tab in Query window.
I suspect you will need to build an expression to check all the Families on an Individual Query, so it might be much easier to do a new Family Query, checking that both the Husband and Wife have a custom Id, or simply that they are both descendants of the Empress.
David, The link Jane gave in her post is a link to a .fhq file. This is a Family Historian Query file, not a plugin. It looks as if she has written the query for you, so all you need to do is download and install it.
Thank you so much for pointing me in the right direction Downloaded the query and saved it to a new directory where I keep my FH files. Clicked on the file and it asked me whether i wanted to sinstall it as a custom query. did that and it installed.
added the columns that I wanted then excluded rows that had nulls and it worked a dream.
I now have a list of all the 413 marriages that have taken place between descendants of the Electress (that I know about)
This web site was made with WebAPP v0.9.9.3.3, a web portal system written in Perl
All trademarks and copyrights on this page are owned by their
respective owners. Comments are owned by the Poster.
Marble theme based on "Crash" theme by my2cents