Retail Database

I am trying set up a retail database. For each sale, I need Product Name and Retail Price. I've figured out how to access the Product Name from a lookup menu. How do I get the price to fill in automatically?

Thanks