Duplicating subsequent field information based on previous information from most recent record with identical field information
I'm not terribly familiar with the vernacular, but here's my best:
I have a "pay to" field, a "category" field and an "amount" field.
When I create a new record, I start in 'payto' which will autocomplete, at which point I tab to 'category' field.
What I am hoping to do is after I hit tab on the auto complete, the 'category' field will automatically populate with the same information that was the most recent 'payto' field of the same 'payto'. Ditto for amount.