Hey All,
I’m trying to create a generic inquiry for PO approvals. My goal is to link the GI to a business event to send to multiple approvers, owners etc. I have everything working except that the email address for the approver does not pull onto my GI.
Tables:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/c7b53ac0-4500-4bec-81ac-ad2f6de3a384.png)
Joins:
POOrder to EPApproval
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/31fbba03-e680-4026-ab1c-44f6752110ae.png)
EPApproval to Contact
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/dea0e406-033d-4a6c-b040-6053ad5561f3.png)
Results: Email address is blank. Email is from the contact table. The contact table for the employee stores their email address.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/934ef183-9e1c-4202-9a50-7197a1928e9e.png)
Thanks!