AnsweredAssumed Answered

Using a Drop Down Menu to look up info in column 1 and populate a value in column 2

Question asked by Dannyboy on Nov 20, 2009
Latest reply on Nov 20, 2009 by philmodjunk

Title

Using a Drop Down Menu to look up info in column 1 and populate a value in column 2

Post

Greetings!
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.

e.g.,  

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].

 

Thanks! 

 

 

Outcomes