Hi, I have a many to many relationship within Airtable and trying to link them with the "Linked To" Field.
One distributor can be associated with either multiple manufacturers, or other distributors. A manufacturer can also be associated with another manufacturer.
--- Project ---
My goal is to find the most commonly used manufacturers between distributors.
The manufacturer is for Packaging Automation equipment, namely a manufacturer who has a machine that can fold up a box automatically, around 20 per minute.
There are many distributors though, that sell a box folding machine, but also with some sensors, some conveyor belts, and then maybe a machine also at the end that can fold the box, or stack the boxes, etc.
In my example (real life), there are manufacturer names Syntegon and Econocorp. And then there is a distributor called "Bay Pack." Bay Pack uses both Syntegon and Econocorp machines. And they also use another distributor who specializes in Conveyers, called SLR Systems.
I decided to keep everything in one table, but maybe best in multiple tables.
Assuming it's okay to have everything in one Airtable table, I want to add Syntegon and Econocorp to the Linked Field in the Bay Pack row. And if I do so, I want the Linked Field in the Syntegon and Econocorp rows to show Bay Pack.
I also want the reverse...if I added Bay Pack to Econocorp, then Econocorp would show up for Bay Pack.
And then if I delete, say Syntegon from Bay Pack, it would delete Bay Pack from Syntegon.
