Aug 23, 2022 05:02 AM
I want to keep different people and their statements/quotes on different topics. My idea was to create a table with all the people and their general data and then for each topic open a separate table with all the people and their quotes and statements.
I was looking for a way to synchronize the first column of one table with the first column of another table, but I only found ways to link other columns.
I also want that if I have 100 people in my first table and I open a table for a new topic, that I have the possibility to automatically add all 100 records with all people (just their names).
I hope you understand what I mean.
Feel free to ask me if you have a question.
I am grateful for any answer.
Have a good day.
Aug 23, 2022 07:37 AM
Hi @Janek_Holthuis ,
Welcome to Airtable Community!
Your question is a bit vague and needs more input. Maybe a screenshot would help
Aug 23, 2022 08:38 AM
i will try to explain it a little bit more.
I want to create a database that stores people and their quotes on certain topics.
For example, I have elon musk and he has 5 quotes on cryptocurrency, 3 on another topic and 2 on yet another topic.
This is a bit too much data for one Table since I want to have many topics.
I want several tables ( one for each topic ) and each of them should have the name of the person in the first column.
So i want to have the first column of several tables synced.
Aug 23, 2022 09:01 AM
That is not possible.
the best way to achieve that would be 3 tables:
And you link those together
Aug 23, 2022 02:20 PM
that is sad.
Whats the best practise to link those tables?
Aug 24, 2022 01:11 AM
I would do it this way
I would then have Linked Records field linking the Quoted table to People and another one linking Quotes to Topics. Check this demo base
This way you can go to People and see all the quotes they have and go to topics and see all the Quotes for those topics.