I have built a Custom Module called Products Leased that is related to Accounts. It also contains a lookup field to Products Module.

I am wanting to store all of the Products each account leases from us. When I lookup a Product I also want to bring over the Unit Price of the product into the new Module Products Leased. Is there a way to auto-fill a field based on the lookup value?