Using a Drop Down Menu to look up info in column 1 and populate a value in column 2
I have an entry form that has a drop down menu driven by a value list from a smaller database. [the value list has 2 columns of info; The drop down selection [model purchased] and a numeric value [Price] in column 2 next to it. The 2 columns of data are the only contents of the smaller database.
Column 1 Column 2
Lenovo Desktop 1229.50
Dell Desktop 1329.50
Apple iMac 1199.00
I need the drop down to pull the column 1 info and show in the "model purchased" field of the entry form [I know how to do that], and the price to be automatically entered into and second field on the entry form named Price from column 2 [Here's where I need some help].