Two of the major limitations of Airtable when creating a link from one table (“Table A”) to another table (“Table B”) is that:
We can ONLY link to the primary field in the other table (“Table B”). To truly unleash massive amounts of power & flexibility & customizability in any database system, we need the ability to MANUALLY CHOOSE which field in “Table A” should be linked to which field in “Table B”.
Linking is always done MANUALLY instead of AUTOMATICALLY. Unlike other database systems, Airtable doesn’t automatically scan for matching values in linked fields — a human must manually intervene by manually linking records.
Obviously, these changes would graduate Airtable from the realm of “beginner-level database program” into a more “advanced-level database program”, but it would enable us to create all sorts of advanced database solutions that we can’t create now. It would also remove lots of migration headaches when importing/migrating data into Airtable from other advanced database apps.