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.

[Alexey_Gusev]

Hi,
Yes, as @Dan_Montoya said, it's because of comma.
I struggled with it by substituting the comma with another divider, then revert changes back.
Now I have better solution - change you formula to 

'"'& YOUR_CURRENT_FORMULA_HERE &'"'

Thus, your values will be quoted and when you copy-paste them to link field, they will be linked without division by comma.
Anyway, it is better to avoid, when possible, using comma (and ampersand) in the value of a primary field.

Solution with switching off 'Allow linking to multiple records" even better, but only when you have one-to-one relation. Usually a have no such relations because if records related one to one, they can be placed in a single table. 

[johngiordani]

Thank you to everyone.