# Trying t link Customer & Contact History via Column values and Relations **URL:** \ **Category:** Ask for Help\ **Created:** [November 11, 2022, 9:47pm UTC](https://community.glideapps.com/t/trying-t-link-customer-contact-history-via-column-values-and-relations/53942 "2022-11-11T21:47:06Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![justin\_m](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/justin_m/32/45432_2.png) [@justin\_m](https://community.glideapps.com/u/justin_m)\ **Post date:** [November 11, 2022, 9:47pm UTC](https://community.glideapps.com/t/trying-t-link-customer-contact-history-via-column-values-and-relations/53942/1 "2022-11-11T21:47:07Z")
I made a [Loom video](https://www.loom.com/share/3b6be9d49f5b4583be319181c18c9c9f) to walk through an issue I’m having with linking my Prospect Table to my Contact History Table in my CRM. I"m doing something wrong with either the form or the relations in the database but I’m not sure what. I’ve watched the tutorials and something isn’t clicking. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [November 11, 2022, 11:05pm UTC](https://community.glideapps.com/t/trying-t-link-customer-contact-history-via-column-values-and-relations/53942/2 "2022-11-11T23:05:34Z")
Can you verify that your relation is set up correctly? Based on your form, it looks like you are filling the Next Step and Prospect ID columns, but what you showed was a different Prospect ID (…) column. I suspect your relation is using the wrong column, and based on the last row that was written, the form is writing the values as expected. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/8/0804345e895005262c850ea13302bb2ed4af507e.png) ---
**Author:** ![justin\_m](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/justin_m/32/45432_2.png) [@justin\_m](https://community.glideapps.com/u/justin_m)\ **Post date:** [November 16, 2022, 12:42pm UTC](https://community.glideapps.com/t/trying-t-link-customer-contact-history-via-column-values-and-relations/53942/3 "2022-11-16T12:42:34Z")
@Jeff_Hager that is probably it but I’m struggling to resolve it. I am going into the relation columns and seeing use cases. Contact History is related to Prospect ID, and vice versa, in both tables. Looking at the Data Sources (Tables) here is what I see. **Table: Prospect List** The unique identifier for a row is Prospect ID The Relation column for Contact History from this table is showing usage of _Prospect List_ \> (relation) _Contact History_ **Table: Contact History** The unique identifier for a row is a formula of a few columns The form seems to be trying to populate a column called Prospects ID 2 and not the Prospect ID. When in the Layout screen, my form has Columns of Prospect ID The destination is the Contact History table. If I go into the Contact History table and hard key in the Prospect ID into Prospect ID 2, then that contact event shows up in the log of contact history on the Propsects table. So, is my relation broken on the Prospects table or the Contact History table? Or both? ![Screenshot 2022-11-16 at 6.30.07 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/a/4a750a3fb8d19db38da14598787419feb15d310e.jpeg) ![Screenshot 2022-11-16 at 6.30.30 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/c/acc478cbe402f9af1c99d31a7e63de20329d5279.jpeg) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [November 20, 2022, 11:40pm UTC](https://community.glideapps.com/t/trying-t-link-customer-contact-history-via-column-values-and-relations/53942/4 "2022-11-20T23:40:40Z")
The usage screenshots don’t really tell me much. How are your relation columns configured? Which columns are they linking together?