This topic is locked

About Dependent Lookup on Master-Detail

1/9/2011 1:15:31 AM
PHPRunner General questions
B
bobotoh author

MASTER_TABLE
[color="#ff0000"]car_id



DETAIL_TABLE

spareparts_id --------------------------> (dependent dropdown based on value in master table)
is it posible to use dependent dropdown on detail table based on a field value in master table (on add page) ?

B
bobotoh author 1/10/2011



MASTER_TABLE
[color="#ff0000"]car_id



DETAIL_TABLE

spareparts_id --------------------------> (dependent dropdown based on value in master table)
is it posible to use dependent dropdown on detail table based on a field value in master table (on add page) ?


still no answer?

Sergey Kornilov admin 1/11/2011

It requires a bit of coding.
Step 1.

Save car_id from master table in session variable like $_SESSION["car_id"]
Step 2.

Add WHERE clause to Lookup wizard

" car_id = " . $_SESSION["car_id"]


This way lookup wizard will be filtered by car_id field value from the master table.

B
bobotoh author 1/11/2011



It requires a bit of coding.
Step 1.

Save car_id from master table in session variable like $_SESSION["car_id"]
Step 2.

Add WHERE clause to Lookup wizard

" car_id = " . $_SESSION["car_id"]


This way lookup wizard will be filtered by car_id field value from the master table.


Thanks admin but,

  1. what do you mean with car_id from master table in session variable like $_SESSION["car_id"] ?

    2. should i put a custom code on PHPRUNNER add event. could you please give an example?*



Sergey Kornilov admin 1/11/2011
  1. This means you need to write a piece of code that saves the value of mater record car_id field in session variable. The actual code depends on details on your application.
  2. In Lookup Wizard setup dialog there is a WHERE clause input box. That's where you need to paste supplied code snippet.
    If you need help doing this post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.

B
bobotoh author 1/12/2011


  1. This means you need to write a piece of code that saves the value of mater record car_id field in session variable. The actual code depends on details on your application.
  2. In Lookup Wizard setup dialog there is a WHERE clause input box. That's where you need to paste supplied code snippet.
    If you need help doing this post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.


i use PHPRUNNER trial version (about one weeks remaining). i doubt trial users can use the xlinesoft support at http://support.xlinesoft.com ..

Sergey Kornilov admin 1/12/2011

Trial users are able to open support tickets.