- Function Name:
- RelationCode
- Description:
- Returns coded numeric values which provide information about how 2 people are related.
- Minimum FH Version:
- 2
- No. of Parameters:
- 4
- Return Type:
- Number
- Parameter 1:
- A reference to an Individual.
- Parameter 2:
- A reference to an Individual.
- Parameter 3:
The item of information required. Possible values are:
- GENERATION
- The number of generations separating the two individuals. For example, if Individual 2 is the uncle of
Individual 1, they will be deemed to be one generation apart, and the value returned will be 1. If they were
siblings, the value returned would be 0. Negative numbers are used to indicate that Individual 2 is of a
younger generation than Individual 1. For example, a son or a nephew would be given a value of -1.
- GENS_UP
- The number of generations back you have to go, to find a common ancestor. For example, an uncle would
have a value of 2 for this. A grandfather (a limiting case) would also have a value of 2. A daughter
(another limiting case) would have a value of 0. A niece would have a value of 1. This function never
returns negative values.
- GENS_DOWN
- Once you have established how many generations back you have to go to find a common ancestor, how many
generations back down again do you have to find the 2nd Individual (or his/her spouse)? GENS_DOWN gives you
this value. So, for example, an ordinary (first) cousin would have a GENS_UP value of 2 and a GENS_DOWN
value of 2 also. A grandmother would have a GENS_UP value of 2 and a GENS_DOWN value of 0. A daughter would
have a GENS_UP value of 0 and a GENS_DOWN value of 1. This function never returns negative values.
- HALF
- This value will be 1 if the two individuals (or their spouses) have only one common ancestor; and 0 if
they have two common ancestors. The only possible values are 0 or 1.
- SPOUSE_START
- This value will be 1 if the two individuals are related by marriage via the spouse of the first
individual. An example would be if the 2nd individual were the mother-in-law of the first individual. The
only possible values are 0 or 1.
- SPOUSE_END
- This value will be 1 if the two individuals are related by marriage via the spouse of the second
individual. An example would be if the 2nd individual were the son-in-law of the first individual. The only
possible values are 0 or 1.
- Parameter 4:
- A number indicating whether the information you want concerns the closest relationship binding the 2
people, the 2nd closest relationship, the 3rd closest relationship, or whichever.
Use a value of 1, here, to represent the closest relationship, 2 to represent the 2nd closest, and so on.
- Examples:
=RelationCode(["Individual"],%INDI%,GENERATION,1)