2. PHPRunner General questions
  3. lookup wizard question
This topic is locked

lookup wizard question

 		8/6/2008 12:44:18 AM
PHPRunner General questions
E
 emsurban author

how do i auto fill other fields in my form once selected a record form drop down list.
I have created a dropdown list using lookup wizard, connected to a table. What i want is when a user selects a record in the drop down list, all other fields in the form will be populated with the data related to the selected record.
Is this possible, thanks in advance.
J
 		Jane 8/6/2008

Hi,
use dependent dropdown boxes for this purpose.

Here is the "How to setup dependent dropdown boxes on Edit/Add pages" tutorial:

http://xlinesoft.com/phprunner/php-database.htm
S
 		swanside 8/6/2008

Have a look at this
How to setup dependent dropdown boxes on Edit/Add pages from Here
S
 		swanside 8/6/2008

Hi,

use dependent dropdown boxes for this purpose.

Here is the "How to setup dependent dropdown boxes on Edit/Add pages" tutorial:

http://xlinesoft.com/phprunner/php-database.htm


You just beat me to that, I went to make a coffee!!!!!
E
 		emsurban author 8/6/2008



You just beat me to that, I went to make a coffee!!!!!


Thanks both of you for the reply.
Let me explain further about my requirements. I want to have a drop down list using lookup table, this dropdown will contain names of my products, what i want is if the user selects one product it will automatically fill one edit box (add or edit page) with the price of the selected product. Is this possible?
T
 		thesofa 8/6/2008

use the $Values() array to get the value chosen in the lookup box, use this value in a query to fetch the price from the table with the prices in, assign this value to a variable and make that variable the default value in a read only for the price box on the form.
E
 		emsurban author 8/6/2008

use the $Values() array to get the value chosen in the lookup box, use this value in a query to fetch the price from the table with the prices in, assign this value to a variable and make that variable the default value in a read only for the price box on the form.


I think this is what i need.... thanks all!