I have the following related tables with corresponding fields
Actions have multiple Initiatives: one to many relationship(1 to *)
Understand Macros cannot do this and it needs to be done with a Query but I would like the query to run only for specific Actions that have been modified, not for all Actions because it will take too long to run.
Is there a way to do this or a simple way to have it done?
thanks!
Actions have multiple Initiatives: one to many relationship(1 to *)
- ActionsTable
- ActionTitle
- ActionID(1)
- ActionTotal
- InitiativesTable
- InitiativeDetail
- InitiativeID
- ActionID(*)
- InitiativeTotal
Understand Macros cannot do this and it needs to be done with a Query but I would like the query to run only for specific Actions that have been modified, not for all Actions because it will take too long to run.
Is there a way to do this or a simple way to have it done?
thanks!