I would like to have one column where its listed projects with different types, examples…roofing, solar, construction but on that tab I would like to list the ones that apply to that specific account. In having multiple selections I would like them to be individually linked to different tabs that I have created for each project. It only allows me to link one thing per column? I can’t have multiples tags in one category to open different links?
Each field (column) can only be linked to one table through a linked record field. When you create a linked record field you will be prompted to choose a table to link to. You can link to more than one record from the linked table, but not to different tables.
If you want to link to two separate tables you will need to create two separate linked record fields.