How do I like tables. I have the following set up.

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

The basics of each table are below. Basically we are using zapier to move data into each table with the following details below. But we need them to all connect together into the customer record area. If that makes sense. The import from zapier will always include the email address which would be used to tie back to the customer record. I am not sure how we can utilize the email field which the email will be populated basically through api to connect to the customer record at the end of the day?

Orders table

  1. Product Name
  2. Email Address
  3. Amount
  4. Date of Purchase

Course Records

  1. Course Name
  2. Date of Completion
  3. Email Address

Customer Records

  1. First Name
  2. Last Name
  3. Email
Photo of Joshua McAfee

Joshua McAfee

  • 0 Points

Posted 4 years ago

  • 0
  • 1
No problem.  Just set the KEY field to your Customer table to be the email field.  In the field list, flag it as the KEY.

Then make a relationship to each of the Orders Table and the Course table with the "Reference" field in the right side of the Relationship also being the email field.