2. PHPRunner General questions
  3. Restrict options based on other selection
This topic is locked

Restrict options based on other selection

 		8/20/2009 9:49:26 PM
PHPRunner General questions
S
 Stucco author

Hello,
I would like to use the "This dropdown is dependent on..." option, but I have a table setup that doesn't seem to allow it.
Here is my table structure.
Customers

customer_id
Shipments

shipment_id

customer_id
Origins

customer_id

name
Legs

shipment_id

origin_id
I am setting up the origin_id field on the legs add/edit page. I need to link it to the origins table and filter the options on customer_id, but my customer_id isn't in the legs table, it's in the linked shipments table.
J
 		Jane 8/21/2009

Hi,
you can create view in the database and join Origins and Shipments tables. Then use this view as lookup table for shipment_id field.
S
 		Stucco author 8/27/2009



Hi,
you can create view in the database and join Origins and Shipments tables. Then use this view as lookup table for shipment_id field.


I have tried to implement this solution, unfortunately it doesn't seem I can choose a view from my dropdown list of which table to start with.
J
 		Jane 8/28/2009

Hi,
please make sure you've created view in the database, not on the Datasource tables tab in PHPRunner.