Skip to main content
Question

Adding a reference field between Tables

  • October 11, 2021
  • 0 replies
  • 81 views
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 Lookup field of "Partner Brands" (multi-select field) which are added in the Affiliate Outreach Table, but I want those Brands to also appear under the Outlets table. It's not currently working.

Does this have anything to do with Outlets being an anchor point for the Outreach Table? I've created the relationship twice, but no luck so far.

------------------------------
Chelsea Giacchi
------------------------------
This topic has been closed for replies.

I think you'll have to describe the relationships between tables a little bit more in order to get a solid answer.

You'll probably end up wanting to use the Report Link field type or the new Formula Queries feature.



------------------------------
Justin Torrence
Quickbase Expert, Jaybird Technologies
jtorrence@jaybirdtechnologies.com
https://www.jaybirdtechnologies.com/#community-post
------------------------------
RaziD
Forum|alt.badge.img+3
  • RaziD
  • Registered
  • October 19, 2021
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.
------------------------------
Razi D. [WebsiteUrl]
Terms & ConditionsAccessibility statement