@tkhk_m Thanks for sharing your database. I think I understand your question now.
You are generating the primary key for Table 2 in the “Formula” field in Table 1.
You’d like the tables to be “automatically” linked based on the foreign_key / primary_key relationship, but as far as I can tell Airtable doesn’t currently allow for lookups into other tables that Airtable doesn’t know are “linked”.
For an Airtable lookup to work (as I’m sure you know), Airtable has to know how the two tables are linked.
It would be great if an Airtable formula could be used to do arbitrary lookups in related (but unlinked) tables, but currently I don’t see any way to do that (without resorting to using their API).
Having a LOOKUP function that could pull data from other related tables without requiring them to be linked by hand.
Some thing like:
LOOKUP (sqlStatement, destinationField)
In your case:
LOOKUP (“select table_2.GetThisInformation from Table_2 where Table_1.Formula = Table_2.Name” , LookUpInformation)
AirTable certainly feels like it is backed by a relational database, but I have no idea if there is traditional SQL database under the hood. Implementing this sort of feature might be much more complex for AirTable, since they let multiple admins modify with the schema (with rollbacks) on a live multi-user system.