How to connect two tables using my specified fields

Ask the Community Get Answers
1

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.

2

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.