An Opportunity creates a child Design record. (1:1). a Design Record creates a Design Version record (1:N). There is also a referential relationship between Opportunity and Design Version. (On Design Version record the opportunity has already been populated
from workflow).
I want to populate the Opportunity Revenue amount from the design version, however I want it to update from the most recently created Design Version record as there will be multiple design versions. Any suggestions on how to accomplish this?