Forum Discussion
DonLarson
5 years agoQrew Elite
Josh,
First make sure that the reference field for each parent reference field has the Blank box cleared.
Create a Formula Text field called Absolute Address
If (
IsNull([Related Transactions] )=false, ToText(),
IsNull([Related Properties])=false, ToText( [Properties - Address]),
IsNull( [Related Projects)]=false , ToText([Projects - Address]), "Error, No Parent Transaction, Property or Project" )
This sequentially goes through your Parent relationships, checks if it exists and converts the Look Up Address to a Text Field.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
First make sure that the reference field for each parent reference field has the Blank box cleared.
Create a Formula Text field called Absolute Address
If (
IsNull([Related Transactions] )=false, ToText(),
IsNull([Related Properties])=false, ToText( [Properties - Address]),
IsNull( [Related Projects)]=false , ToText([Projects - Address]), "Error, No Parent Transaction, Property or Project" )
This sequentially goes through your Parent relationships, checks if it exists and converts the Look Up Address to a Text Field.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------