I am having a hard time understanding the many to many table linking situation and how it can help me. I have 2 tables with the same data columns. I want to combine both on a master table. My issue is when one column is linked to one table then how in the world will you on the next row down get the information from another Table I need?
David, thanks for you response. Note I am aware this data can be placed in one table. What I have is multiple projects listed by address that have their own table. Each table has a separate user. I want that data to translate to the master table with the data columns repeated in each. Once in the same data order(columns) but not row order(just get in their) I am then grouping trades and companies for management to view lots of consolidated data for their use.
My intention is avoid data input into the master.
That still sounds like it would be better done in one table. You can then have a Master view, and different views for each address (or user). That is what Views are designed for. Airtable is not really designed to have tables that duplicate the same records as other tables.
In agreement with @David_Skinner 's comments, it really is bad form to have multiple tables with the same data structure.
Even if there were a clean way to implement the idea of the ‘item master’ be a compilation of the other 2 tables, it would still change whenever the other tables data would change so there would be no actual difference in the data.
note at some point each table is done being worked on. Its not running on forever but the goal is ever time a new project/table is created the master table will include this data also.
Every project has a different table because they have specific views setup already. I want to take that Master Data from each table and compile it into one.\
I’ll take a look at that combining multiple AT support link and go from there.