2. PHPRunner General questions
  3. Lookup wizard
This topic is locked

Lookup wizard

 		9/8/2005 5:28:08 AM
PHPRunner General questions
J
 Jack author

I would like to extend the functionality of the lookup wizard on my _add page to be able to INSERT other fields in addition to the linked field of the selected record into a table. For example, If I select 'ProductID' from the 'Product' lookup table, I would like to INSERT 'ProductID' AND 'ProductPrice' from the 'Product' table INTO the "GoodsSold' table. The 'GoodsSold' table is for archival data, and the value of the 'ProductPrice' field in the 'Product' table will change over time, so volatile data in the 'GoodsSold' table cannot be linked to the 'Product' table. A solution based on hardcoding the SQL string would be fine for me.
Thanks for a great product and excellent support,

Jack
Sergey Kornilov admin 9/8/2005

Jack,
you can use dependent dropdown boxes, where values shown in the 'ProductPrice' dropdown box depend on the 'ProductID' you've chosen in the first lookup wizard.
Proceed to the "GoodsSold' table - Formatting tab in PHPRunner.

Set Edit as - Lookup wizard type for ProductPrice field. Choose Lookup table: Product, Link/Display field: ProductPrice.

Check off the box This dropdown is dependent on .... Set Category control/ Category field: ProductID.
J
 		Jack author 9/8/2005

Hi Sergey,
If I understand you correctly, what you are suggesting will work for editing data only. The need that I described is for adding data. Am I missing something?
Regards,

Jack
Sergey Kornilov admin 9/9/2005

Jack,
this will work on both Add and Edit pages.
J
 		Jack author 9/9/2005

Sergey,
I have 3 fields on an _ADD page each formatted as a lookup wizard. I have the second field lookup dependent on the first field selection using the category control. I am not able to get the third field lookup dependent on the second field selections. Should this be possible?
Thanks,

Jack
E
 		eocasio 9/11/2005

I experienced the same problem and did find another post from Sergey that there is no solution at this time. The dependent lookup only works for one field.