* Query for Multiple Marriages

Homeless Posts from the old forum system
Locked
avatar
oldtimer47
Diamond
Posts: 56
Joined: 23 Dec 2008 07:01
Family Historian: None

Query for Multiple Marriages

Post by oldtimer47 » 03 Oct 2009 18:26

I'm trying to write a query to identify individuals with multiple marriages (i.e. 2 or more marriages). I have tried various filters based on %indi.nmr% but can only seem to get an empty list or a list of everybody.

I'm sure it must be possible and would greatly appreciate any suggestions as to how to do it.

Many Thanks
Peter

ID:4043

User avatar
Jane
Site Admin
Posts: 8442
Joined: 01 Nov 2002 15:00
Family Historian: V7
Location: Somerset, England
Contact:

Query for Multiple Marriages

Post by Jane » 04 Oct 2009 09:32

The simplest way would be to check for the existence of a second family as spouse record

so

%INDI.FAMS[2]>% is not null

avatar
oldtimer47
Diamond
Posts: 56
Joined: 23 Dec 2008 07:01
Family Historian: None

Query for Multiple Marriages

Post by oldtimer47 » 04 Oct 2009 09:44

Jane

Thanks for the pointer - I'm just getting into the programming capabilities of FH4 and seeing examples of code that do what I want is very helpful.

Peter

Locked