- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 22, 2024 03:07 PM
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:
- duplicated the deals Table
- attempted to then link back to Deals
- 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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 22, 2024 06:57 PM
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 Dan_Montoya](https://community.airtable.com/legacyfs/online/avatars/3X/0/1/010965c60346a4c0a3822a7b9d60902810f24a11.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 22, 2024 08:38 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 23, 2024 01:06 PM - edited ‎Oct 23, 2024 01:13 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 28, 2024 11:17 AM
Thank you to everyone.
![](/skins/images/FE00829FDD2AE889FAB731D8F02A8942/responsive_peak/images/icon_anonymous_message.png)