I’m not sure if I understand what you want to achieve.
My questions are:
Shall the list of samples in your new table be five separate rows? Or do you want one single row that list the five samples that belong to “Lung”? (as you have it in table “Workflow”)
You named the new table “Lung”. Are you planning to have only data for “Lung”? Will there be other new tables like “Kidney”?
I would like to list of samples in the new table be five separate rows. Because I want to add specific variables/field that belongs to lung for each sample.
Yes, this table will only belong to lung. Kidney samples will go into different table (new tables to be added).
The aim is that each Tissues (lung, kidney, heart…) should have some specific variables/field but they derived from the table “Sample”.
Okay, I think I got an idea of what you are looking for.
In general: I think it is a typical question related to designing a database. However, this is a question that is not specific to Baserow, but rather to any database you might use.
The term for answering your question is Database Normalization (Wikipedia)
You might find some helpful pages if you search for “database normalization” on the web.
Returning to your question in more detail: I would start by asking whether tissue samples from the lung or kidney really have a lot of different specific variables, fields or parameters. Are samples from the lung and kidney completely different? Do they really have to be stored in different tables? Tables that are not hierarchically related to each other, but simply live ‘beside’ each other, are difficult to join together as you would like to do.
Is there a chance to list them all in one table, add all the fields (columns) you need and use different views for lung and kidney to hide the fields that you don’t need for kidney or lung?
As - from my understanding - this is not a technical question specifically related to Baserow, I don’t think I can help any further in this forum.
