* Display Ind. ID in Family Query

Homeless Posts from the old forum system
Locked
User avatar
kathykult
Gold
Posts: 17
Joined: 17 Aug 2006 15:07
Family Historian: V7
Location: Belvidere, IL
Contact:

Display Ind. ID in Family Query

Post by kathykult »

I'd like to display the Husband's Individual RecordID (as well as his Wife's) within a 'Family' Query. As =RecordID() returns the FamilyID, I've tried things like %FAM.HUSB>RecordID()%, but that's not valid. I've tried %FAM.HUSB>RFN%, REFN%, and RIN%, none of which display the actual RecordID. What is the Query Expression to do that? I can't find what I want in the help files anywhere.[question]

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

Display Ind. ID in Family Query

Post by Jane »

When using functions you put the data expression with in them.

so

=recordid(%FAM.HUSB>%)

=recordid(%FAM.WIFE>%)
User avatar
kathykult
Gold
Posts: 17
Joined: 17 Aug 2006 15:07
Family Historian: V7
Location: Belvidere, IL
Contact:

Display Ind. ID in Family Query

Post by kathykult »

Aha! Thanks so much Jane! [grin] That works beautifully.
Locked