Adding a reference field between Tables
I have two tables and I need a field from Table "Affiliate Outreach" to pull into Table "Outlets" based on the "Outlet Name" which is included in both tables. I created the relationship to add the Loo...
Forum Discussion
Hi Chelsea;
I agree with Justin, we need to know details of relationship. I might be wrong but it sounds like:
Your master table is Outlets table and key field is Outlet Name.
I think you created combined text field(summary field) to see all Partner brands from Affiliate Outreach table(child table) in Outlet table.
Combined text fields and summary fields don't(may not) work if the related field(in child table - Affiliate Outreach) is a lookup from another table.
Thank you
------------------------------
Razi D.
------------------------------
I agree with Justin, we need to know details of relationship. I might be wrong but it sounds like:
Your master table is Outlets table and key field is Outlet Name.
I think you created combined text field(summary field) to see all Partner brands from Affiliate Outreach table(child table) in Outlet table.
Combined text fields and summary fields don't(may not) work if the related field(in child table - Affiliate Outreach) is a lookup from another table.
Thank you
------------------------------
Razi D.
------------------------------
