I have the following objects:
• Asset Move
Location (Parent) has a master detail relationship with Asset (Child)
Asset (Parent) has a master detail relationship with Asset Move (Child)
Asset Move has a lookup relationship to location. The field is called (Destination Location).
Basically, I’d like to define an asset and link it to a location. But once I make an asset move, I need to asset’s location to re-parent again to reflect the location defined in the destination location.
I believe this can be done using a trigger. Please start your bid with the word trigger so I can know that you’ve read this text.