Howdy!
I have a list of all of my vendor partners, which includes a single select column for the type of vendor. I would like to create another table with a filtered list of my partners of a specific type, web integrators.
I would like to do this because I have some additional columns of data that I would like to add and track, but they are only relevant for the web integrators and not relevant for all of the other partner types. The Company Name would be the primary field on both tables.
Ideal, I would be able to create a new table will all my tagged web integrators, such that when I add a new partner to my main list and tag them as a web integrator, they will appear on the new table and I can update the additional columns in the new table.
What is the best way to achieve this use case?