2. PHPRunner General questions
  3. lookup table data depending on another lookup
This topic is locked

lookup table data depending on another lookup

 		5/26/2005 12:19:39
PHPRunner General questions
R
 reycruzva author

I need to populate a lookup table depending upon the user selection on 1st lookup table.
Master-Detail relationship works great!
Situation!
Adding or Editing:
When the user selects "Car Make" from the 1st lookup table, 2nd lookup table will show "Car Models" in relation to the 1st lookup table.
Do I need to add some scripting to acomplish this?
Ive seen lots of javascript examples on the internet.
Im sure its fairly simple to do, but I am burn out trying to do it.
Does PHPRunner has the way to make this posible without extra coding?
Can Anyone?
Sergey Kornilov admin 5/30/2005

Hi,
you can use dependent dropdown boxes, where values shown in the second dropdown box depend on the value you've chosen in the first one.
Proceed to Formattingtab in PHPRunner and set Edit as - Lookup wizardtype for Car Make field.

Set Edit as - Lookup wizardtype for Car Models field.
Check in the dependent dropdown box This dropdown is dependent on ...

Choose Category control - field, defining list of categories and Category field - field from dependent table, containing category value.
After setup press Test it button, to check how it will work.
R
 		reycruzva author 5/31/2005

Thanks for your Help!!!!
I don't know if I understood you correctly.
My PHPRunner is version 1.1 and I am a little confuse.
According to your advice, I can use "Dependent dropdown box"
This feature is not showing!
How can I get the new version if any?
Thanks again!
Sergey Kornilov admin 6/1/2005

Hi,
you can download PHPRunner 2.0 version here
500250 6/30/2005

Admin,
I have tried looking at the Help files and follow your directions above, but I still am not able to get a dependent dropdown list to work.
If the first drop-down had apples and oranges as values, and the second drop-down showed the types of apples and oranges depending on the first choice, how would I set up the table(s) and PHPRunner in order to do so?
prleo1 6/30/2005

If I had the following table, how would I configure PHPRunner to create a dependent drop down list.
Fruit Table

------------------------

fruit_id pk

fruit_type

fruit_name
fruit_id | fruit_type | fruit_name

1 | apple | red delicious

2 | apple | granny applye

3 | orange | navel orange

4 | orange | nectarine
drop down 1: apple or orange

drop down 2: dependent on 1
Sergey Kornilov admin 6/30/2005

Hi,
you need to configure lookup wizards like it shown on this picture.