Page 1 of 1

Display Ind. ID in Family Query

Posted: 10 Jun 2009 00:37
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

Display Ind. ID in Family Query

Posted: 10 Jun 2009 07:31
by Jane
When using functions you put the data expression with in them.

so

=recordid(%FAM.HUSB>%)

=recordid(%FAM.WIFE>%)

Display Ind. ID in Family Query

Posted: 11 Jun 2009 01:58
by kathykult
Aha! Thanks so much Jane! [grin] That works beautifully.