# How to connect two tables using my specified fields

**URL:** <https://forums.knack.com/t/how-to-connect-two-tables-using-my-specified-fields/20043>\
**Category:** Get Answers\
**Created:** [November 14, 2025, 10:31pm UTC](https://forums.knack.com/t/how-to-connect-two-tables-using-my-specified-fields/20043 "2025-11-14T22:31:52Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Greymont](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/greymont/32/1975_2.png) [@Greymont](https://forums.knack.com/u/Greymont)\
**Post date:** [November 14, 2025, 10:31pm UTC](https://forums.knack.com/t/how-to-connect-two-tables-using-my-specified-fields/20043/1 "2025-11-14T22:31:52Z")

</div>

I have a table of imported data, Group Emails. Many records have the same GroupEmail field values. Within a GroupEmail value, many records contain a MemberEmail field with various values. Our existing Person table also includes each person’s EmailAddress.

I want to connect the GroupEmails table to the Person table where the GroupEmails.MemberEmail equals the Person.EmailAddress so I can display the Person.FirstName and Person.LastName when viewing the GroupEmails table data.

I have connected GroupEmails to Person in a many-one connection since many GroupEmail records will map to a single Person. But beyond that, I am stumped. **How do I specify exactly how to make this connection?** I am working in Next Gen.

I have searched and read many pages in the docs and community forum, but have found nothing that addresses this.

---

<div class="post-metadata">

**Author:** ![PeterG](https://avatars.discourse-cdn.com/v4/letter/p/977dab/32.png) [@PeterG](https://forums.knack.com/u/PeterG)\
**Post date:** [November 16, 2025, 6:16pm UTC](https://forums.knack.com/t/how-to-connect-two-tables-using-my-specified-fields/20043/2 "2025-11-16T18:16:26Z")

</div>

This isn’t like SQL (even if it is a SQL backend) where you have matching keys and the records are automatically linked. You’ve linked the tables, but not the records. That’s because Knack has a hidden key field that would be used for the actual linking value. You have two choices:

1. Do a lookup of each GroupEmails record to the Persons table. This is not practical if you have more than a few dozen records.
2. Export (if necessary) the GroupEmails table records to a CSV fikle and then import them again as an Update making sure you fill-in the proper linking field.

Then you two tables will be properly linked.

---

<div class="post-metadata">

**Author:** ![Paul6](https://avatars.discourse-cdn.com/v4/letter/p/ee7513/32.png) [@Paul6](https://forums.knack.com/u/Paul6)\
**Post date:** [November 30, 2025, 8:04pm UTC](https://forums.knack.com/t/how-to-connect-two-tables-using-my-specified-fields/20043/3 "2025-11-30T20:04:44Z")

</div>

Adding to this:  
Or you can add it in a workflow and force it to update it twice by using a comment UID.  
Zapier and Make can help you with a loop to solve this. But

yeah. CSV, is the fastest.