Skip to main content

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:

 

Joins:

POOrder to EPApproval

 

 

 

EPApproval to Contact

Results: Email address is blank. Email is from the contact table. The contact table for the employee stores their email address. 

 

 

 

Thanks!

Hey @etrojan28,

Try using using OwnerID in your EPApproval to Contact joins instead of ApprovedByID.  As you have it now, it will only pull the Email address of the Contact after it’s been approved.

Hope that helps!


@craig2 thanks for the speedy reply Craig. That was it. 

 

Thanks!


Reply