2. PHPRunner General questions
  3. populate other fields after lookup
This topic is locked

populate other fields after lookup

 		9/16/2009 01:38:50
PHPRunner General questions
M
 meirco author

setting a field as lookup I need to populate other information from the lookup table to the current table

exaple entering codes into time table my lookup field is tcode my lookup table is codes I need to update time.description field in time table from description field in codes table .
lookup table : codes

linkfield: tcode

display field: tcode

orderbt : tcode
list page is checked.
where do i add :

time.description=codes.description
as you can tell i'm just starting with this mysql php .

thanks.
J
 		Jane 9/16/2009

Hi,
I recommend you to use dependent dropdown boxes for this purpose.

Check 'How to setup dependent dropdown boxes on Edit/Add pages' tutorial here:

http://www.xlinesoft.com/phprunner/php-database.htm
M
 		meirco author 9/17/2009



Hi,
I recommend you to use dependent dropdown boxes for this purpose.

Check 'How to setup dependent dropdown boxes on Edit/Add pages' tutorial here:

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


Thanks for reply.

I just need to grab the values of a description field as a start of text the rest of the entry is a text box.
grabbing the transaction code by lookup i want to assign the description to a variable

and populate the next entry with that value.
the dropdown boxes do that but my next field is not a dropdown.
J
 		Jane 9/18/2009

Hi,
I recommend you to publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with detailed description of what you want to achieve.