* INDI's ID in a family-type query?

Homeless Posts from the old forum system
Locked
avatar
SabineS
Diamond
Posts: 67
Joined: 11 Jan 2005 14:17
Family Historian: None

INDI's ID in a family-type query?

Post by SabineS » 13 Jul 2005 19:55

How can I get the ID of an individual person into a family-type query? I tried:
=RecordId(%INDI.~FATH>%),
but that does not work with family-type queries.

Sabine


ID:977

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

INDI's ID in a family-type query?

Post by Jane » 13 Jul 2005 21:00

Obivously to get the ID in a family query you need to start from a family rather than an INDI record.

As usual the best way to do this is to use the data reference files list pick the route information and then wrap the function around it.

So
%FAM.HUSB> returns the husband, therefore
=RecordId(%FAM.HUSB>%)
returns the husbands record id
FAM.WIFE> returns the wife, therefore
=RecordId(%FAM.WIFE>%)
returns the wifes record id

avatar
SabineS
Diamond
Posts: 67
Joined: 11 Jan 2005 14:17
Family Historian: None

INDI's ID in a family-type query?

Post by SabineS » 14 Jul 2005 07:04

Jane,

thanks again - those data references are hard to understand, but once one has got them, they are extremely powerful. One of the most interesting features in this software.

Sabine

Locked