I'm building an estimate and have a couple of values that I'd like to pre-populate from the last record created in that application.

The first is a lookup record, my Project Name called Project_Name from the New Project table. This is being used to tie all budget items to a specific project. I'm currently choosing this in every entry I make. If there is a better way to do this, please tell me. While this works, It's a bit cumbersome.

The second field I'd like to auto-populate is my accounting code, called Accounting_Code, which is pulled from an integration from Quickbooks Online from the last entered record. 

Thanks,

Lynn