How to use data from current record.

Summary:

We are trying to create an autocomplete rule to populate an 'average hours' field based on information input through an assignment change. The rule is working other than it is using the working hours on the last assignment record and not the new hours input through the change. How do we get the rule to use the hours input on the assignment change?

Thank you for any advice.

Content (required):

See attachment

Version (include the version you are using, if applicable):

myOracle 23b

Code Snippet (add any code snippets that support your topic, if applicable):