This content has been marked as final. Show 1 reply
Obviously, you need two relationships between Letters and Contacts. I am not sure what role your existing relationship plays here. I would do something like this:
Letters::BuyerID = Contacts::ContactID
Relationship #2 (requires placing a new occurrence of the Contacts table on the relationships graph):
Letters::SellerID = Contacts 2::ContactID
This way you can write:
Hi <<Contacts::Name>>, I'm very glad to annunce you that <<Contacts 2::Name>> will ships the book tomorrow.