How to use the Main column and link to other sheets

[Roland_Ligtenbe]

I’m looking for some help in how to set this up properly.

My main table has the 1st column that is an App.

Table 1:
App1
App2
App3

I’d like to to have another table where the main 1st column is directly linked and the same as on Table 1.
App1
App2
App3

without just copying and pasting them over.

I have another Table that is “Company” that has all the data on the company that created the App1 which is simple to link via relational because the column 1.

[Mohamed_Swella1 · Accepted solution]

Hi @Roland_Ligtenberg,

Welcome to Airtable Community! :slightly_smiling_face:

It doesnt seem right to have 2 tables with exactly the same info in the Primary Field. In addition to that, the primary field cannot be linked to another table, the way around it is to have the link in the 2nd field and then have the primary field as a formula that reads from the this field.

If you want to avoid copy paste then you have to use Zapier to make it automatic.

Hope this helps. If it does, please mark it as Solution so others can see it.

BR,
Mo

[Roland_Ligtenbe]

Thanks Mo! I guess I should get used to views/filters/hidden fields if I want it all in one big table.

[Mohamed_Swella1]

That is definitely one of the most powerful tools of Airtable :slightly_smiling_face: you should use views as much as possible.