Parameters
File Root = Marilyn Marie CAULK
File Owner = Gary Carson
Custom Relationship Expressions for Report(s)
=Relationship(FileRoot()) to %CUR_FILE_ROOT% returns “half 1st cousin 7 times removed to Marilyn Marie CAULK”. This is correct.
=Relationship(FileRoot(),%CUR_FILE_OWNER%,,) to %CUR_FILE_OWNER% returns “=Relationship(FileRoot(),%CUR_FILE_OWNER%,,) to Gary Carson”. This is not as intended. It should return “wife's half 1st cousin 7 times removed to Gary Carson”
How do I correct =Relationship(FileRoot(),%CUR_FILE_OWNER%,,) to %CUR_FILE_OWNER%
* Custom Relationship Expressions for Report(s)
- Gary Carson
- Famous
- Posts: 162
- Joined: 02 Mar 2016 17:46
- Family Historian: V7
- Location: Grand Island, Nebraska, USA
Custom Relationship Expressions for Report(s)
Gary
Win 10, FH 7.0.15
Win 10, FH 7.0.15
- tatewise
- Megastar
- Posts: 28414
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Custom Relationship Expressions for Report(s)
It is not possible to get that to work because %CUR_FILE_OWNER% does not refer to an Individual record.
Notice how the surname is not capitalized.
It refers to a plain text Name field in the Submitter record, i.e. =Field(Record(1,"U"), 'SUBM.NAME')
Notice how the surname is not capitalized.
It refers to a plain text Name field in the Submitter record, i.e. =Field(Record(1,"U"), 'SUBM.NAME')
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
- Gary Carson
- Famous
- Posts: 162
- Joined: 02 Mar 2016 17:46
- Family Historian: V7
- Location: Grand Island, Nebraska, USA
Re: Custom Relationship Expressions for Report(s)
How should I write the expression to relate to specific individual?
Gary
Win 10, FH 7.0.15
Win 10, FH 7.0.15
- tatewise
- Megastar
- Posts: 28414
- Joined: 25 May 2010 11:00
- Family Historian: V7
- Location: Torbay, Devon, UK
- Contact:
Re: Custom Relationship Expressions for Report(s)
Use Record(123,"I") to refer to Individual record with Record ID 123
=Relationship(FileRoot(),Record(123,"I"),,) to =Record(123,"I")
=Relationship(FileRoot(),Record(123,"I"),,) to =Record(123,"I")
Mike Tate ~ researching the Tate and Scott family history ~ tatewise ancestry
- Gary Carson
- Famous
- Posts: 162
- Joined: 02 Mar 2016 17:46
- Family Historian: V7
- Location: Grand Island, Nebraska, USA