Forum Discussion
JustinTorrence
7 years agoQrew Cadet
Here is a summary of what it might look like.
You might have some trouble if you want to run this on a schedule instead of being triggered by a record modification.
Trigger:
When Project record is modified
Action 1:
Copy Records from "Project" table where the "Project" Record ID# is equal to the trigger's Record ID#
Action 2:
Copy Records from the "Parts" table where the Parts Related Project is equal to the trigger's Record ID#
You might have some trouble if you want to run this on a schedule instead of being triggered by a record modification.
Trigger:
When Project record is modified
Action 1:
Copy Records from "Project" table where the "Project" Record ID# is equal to the trigger's Record ID#
Action 2:
Copy Records from the "Parts" table where the Parts Related Project is equal to the trigger's Record ID#