Using Formulas, Actions or Other Means to Auto-relate Records or Facilitate Field Changes
Wracking my brain...
I have a "Resources" table, and a "Properties" table. They have a many-to-many intermediary table "Resource Assignments" (child to both) which relates "Resources" and "Properties". I have a third table that is "Incidents" (child) related to "Properties". See diagram for clarity on the end goal.
I have been wracking my brain trying to solve how to minimize relationship/data maintenance by relating "Resources" to "Incidents" (or adding an auto-filled field as filter).
1. I can't relate Resources-Incidents (employees come and go)
2. I can't relate Resources-Properties (increased relationship management, and it's be nicer to report on any Resource's Incidents as child to Properties)
Questions/Brainstorming:
-Is it possible to use a formula across tables or applications to achieve some automation?
-Is it possible to use Actions to achieve this?
-Could I create a new parent table to Properties and Resources that could auto-fill set fields on which reporting filtering could be achieved?