Discussions

Expand all | Collapse all

Adding a reference field between Tables

  • 1.  Adding a reference field between Tables

    Posted 12 days ago
    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
    ------------------------------


  • 2.  RE: Adding a reference field between Tables

    Posted 6 days ago

    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
    ------------------------------



  • 3.  RE: Adding a reference field between Tables

    Posted 4 days ago
    Edited by Razi D 4 days ago
    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.
    ------------------------------