You could go the to the related records for the tenants (Go to Related Records ) that are linked to the agreement record. Then you can gather the information with a loop. Another option would be to use a calculation from the agreement record using List ( ). I think in your case though I may choose using the loop from the tenants layout.
Being made aware of the List() function has helped me loads, thanks very much. I'm interested in the go to related record solution though seeing as that was your preferred solution for this.
Obviously your suggested a scripted solution but how does that work with a mail merge? I mean, it might be perfectly acceptable and but If I have 100 or so letters to print in a found set, how would I implement a script? Would a script trigger set for when the layout loads work here? I'm thinking it would need to recalulate/run the script 100 times for 100 letters.
You could have your scripe Loop through the records and send the emails.
Yeah I guess. For the moment i've used the List() function for the address field and the below in a calculated field for the salutation.
You helped me a lot, I'm really grateful to you.
This works for two tenants which at the moment is the maximum number of tenants we have in a single property.
If (ValueCount(List(tenants::salut)) >1;
Replace ( List(tenants::salut) ; Position(List(tenants::salut) ;"¶";1;1) ; 1 ; " & " );
How about: Substitute ( List ( tenants::salut ) ; ¶; " and " )
You're a genius