Hi. I am a very new Airtable user, so hopefully this is an easy fix… but I haven’t yet been able to make it happen. We have a CRM base happening, with many tables linked. (Orgs, Contacts, Programs, Sponsors,… and more tabs.) The Sponsors tab has a multiselect field of Programs, which are of course flushed out in the Programs tab. I want to create a new table with all Sponsors of a new Program included in it. I don’t want one line for the Program, with all the sponsors in one cell, I want a line per Sponsor, so I can track their assets, contacts, where we are in the invoicing process, etc. It will be a project management sort of table, but linking to one program.
Is this possible? And, if so, how?