Autofill based on the other field

[Loverkillers]

Hi,
I have 2 tables. 1 is Sales and 1 is Product. The Product table contain 2 field which are product name and product price. In the Sales table have a field that have combo box of product name and I want to a field in Sales table that will show the product price automatically when I choose one of the product name in the combo box.

Please teach me how to do this step by step.

Thank you!

 

[iliyanuhu]

This concept work fine on a form, if possible why not create form for your data entry.