IvanWeiss
2 years agoQrew Captain
Summarize Email field in Table Relationship
Hi everyone, I have a table of contacts that I am using for a spec credit registration app. The nature of the app is it is a new app connected to my main ERP app called Team Elite. In this spec credit app I have a table called Spec Credit Program. It has a relation to the Companies table in my ERP app (Team Elite). In the Companies Table I added a new relationship to my contacts table so that I can select the contact I need to send the spec credit registration too.
The issue is I need to get the email addresses (field in the contacts app) UP to the Companies table and DOWN to the Spec Credit Program table in the other app. I cannot figure out how to create a combined text list of email addresses up on the companies table. How do I summarize email addresses in the relationship?
The app structure is:
Companies (Team Elite) < Contacts (Team Elite)
Companies (Team Elite) < Spec Credit Programs (Elite Spec)
Table Name (App) <=one to many relationship of Table Name (App)
------------------------------
Ivan Weiss
------------------------------
The issue is I need to get the email addresses (field in the contacts app) UP to the Companies table and DOWN to the Spec Credit Program table in the other app. I cannot figure out how to create a combined text list of email addresses up on the companies table. How do I summarize email addresses in the relationship?
The app structure is:
Companies (Team Elite) < Contacts (Team Elite)
Companies (Team Elite) < Spec Credit Programs (Elite Spec)
Table Name (App) <=one to many relationship of Table Name (App)
------------------------------
Ivan Weiss
------------------------------