Autofill (lookup) from one table to another?

When selecting the product id field in detail sale, I want to bring the price or more fields from the Products table.

Please note that this is currently not available, but you have the option of applying your custom code.