Would it be possible to have a field type : “link to another table” - similar to “link to another record” but allows linking to other tables in the same base.
For example, within the same base, I have : 1 table with a list of tasks and 10 tables for different procedures, within each of these, there is a large list of tasks.
I would like to link tasks in my first table to tasks in any of the other tables.
At the moment I have to add a column for each of my 10 tables within which I have to define a subtask in order to have a record in the cell, it would be so much easier to have one column where I choose a table I want to link the record to and then maybe a second column with the record within that table.
... View more