A bank wants to do a "Work Order" (similar to service request) that will collect information that will be assigned to a Loan Servicing team that will process an existing loan to do a loan rate modification. The work order starts with the Financial Account, in this case a loan. The loan has a relationship to customers. In this case Mr Caron, and Mrs Caron. We want both customers to be listed in this Work Order, or related to the work order. I believe they could both be brought in to a doc merge (although I have not tried yet), but it is also important for the Loan Servicer to see there are multiple borrowers so they can be notified, listed and included in all correspondence both in and not in the CRM. Using a Calculated field and a Relate will only give the last result. There can be many customers related to one Financial Account. Is there a way to have them either in the work order or related to the work order with out having to manually relate them. It seems there should be a way since they are already related to the parent Financial Account.
Thank you for any thoughts or suggestions,
Mathew