Help out a newbie?

[johngiordani]

I am in real estate. I started with a Deals table, but now realize I should have a Properties table...so I did the following:

1. duplicated the deals Table
2. attempted to then link back to Deals
3. But won't let me copy and paste

Here is a link to a video...please help. Thank you everyone.

https://share.zight.com/BluPqq0j

Best,

John

jgiordani@gmail.com

[TheTimeSavingCo]

I think the comma might be confusing the linking.  They're one to one links, so try toggling off "Allow linking to multiple records":
 

Should work fine after that:

  

[Dan_Montoya]

The issue is that you have a comma in between the city and state.  Airtable will see that as 2 different records it is trying to link to.  So when you have a value of "freeholde, NJ" it is seaching for "freeholde" and "NJ" which do not exist in your base.  A fast way to resolve this is to create a new field without the comma in the deals table, remove the comma from the properties table primary key, then link the two that way.