Hi @Henry_Meiklejohn1 ,

welcome to Airtable community.

The best scenario is to have all your projects in a master document and then to share multiple views to different tables. However on what you have described you have multiple tables and you want to create a master table based on them.

I recommend to sync all those tables to the new base where actually you gone have one table for every synced table separately. Then you have to find the common field which you could you use as a matching key in order to create “linked to” fields and then you will have the master table.

For any further question please do not hesitate to post back to community. Please, if you try it post here your results.

Thanks

Thanks for the reply @Dimitris_Goudis , I ended up creating a new base with one table listing all the projects, and then created multiple views corresponding to each functional area. Then I synced each view to the corresponding base. I ended up deleting the old “Project” tables from each base. I have exactly what I need now. Not sure if this is exactly what you were describing, but either way your comment led me to that, so thank you very much.

Hi Henry,

This is what I mean . I am very happy that this solution worked. Please don’t forget to mark the post as solved.

Thanks