There may be a way to do this using the help of an integration service like Zapier or Integromat. Aside from that, the best I can come up with involves a slight change to your process. Rather than manually build links from the [Words] table to the [Phrases] table, work the other way around, and let Airtable help with the link building.
In your [Phrases] table, add a formula field (I called mine {Split}) that replaces the spaces in your phrases with comma-space combos, like so:
SUBSTITUTE(Phrases, " ", ", ")
Next to this, add a link field that points to your [Words] table, and which allows for linking to multiple records. We’ll get to that in a moment.
Now start filling up your main {Phrases} field as you like, watching the split phrases appear in the adjacent field:
Once you’ve got a bunch of phrases built, copy the contents of the relevant entries in the {Split} field, and paste them into the adjacent field linking to your [Words] table. The end result should look like this:
Now jump to your [Words] table, and each word will be linked to the relevant phrases. Airtable will even make new records for words that didn’t previously exist. When I started this, I only had a “car” record. Airtable added the other three:
It’s still a manual process, but now it’s just copying and pasting from one field to another, and letting Airtable take care of the links.
