Is there a way to automatically fill records in one table based off a tag in another table?
I have a table that lists applications (Applications table) and various fields with details related to each application, along with application status (funded, not funded). I want to create another table (Funded table) in order to fill in specific details for funded groups.
I know I can use create a filtered view of the main Applications table to show only Funded groups, but I am trying to avoid convoluting that table too much – as the Applications table is intended to track details related to the application process only, and I wanted to add and track different details for funded groups in another table. Any ideas for how I can accomplish this?
Thanks for the help!