This topic is locked

Dependent Dropdown Listbox

11/24/2005 10:46:56 PM
PHPRunner General questions
D
Devon author

I have a situation that makes me think I am misunderstanding hwo to use teh dependent dropdown listbox feature.
I have three tables (actually more.. but for this discussion I will try and only give relevant info)
Table A has these fields
Usage_ID: {unique, key field}

Product_ID

Date
Table B has these fields
Product_ID {unique, key field}

Manufacture_ID

Product_Name

Product_Price

Product_Details
Table C
Manufacture_ID {unique, key field}

Manufacture_Rating

Manufacture_Info
In a form Table A is the main table. I am trying to have a drop downdown that first lists the manufacture and once that is selected, lists product names from the manufature. The product_id is them what is stored in that field.
When I setup my loop up wizard like this:
Table: Table A

Link Field: Product ID

Display Field: Product Name

Order By:
check the box
Category Control: Manufacture_ID

Category Field: Manufacture_ID
and do teh "test it" button. It seems to work fien and shows me proper info.
Manufature drop list box on top, next bos is product names only for that manufacturer, and teh selected value matches the product ID of the selected product.
Yet, when published, it shows nothing in the dropdown.
Any ideas?

Sergey Kornilov admin 11/25/2005

Hi,
you need Manufacture_IDfield in table Ato get this working.
Select Table Aon Datasource tabletab in PHPRunner and proceed to Formattingtab.

Set the Manufacture_ID edit type as Lookup Wizardwith the following settings:

Table - C

Lik field - Manufacture_ID

Display field - Manufacture_Info
Then set the Product_ID edit type as Lookup Wizardwith the following settings:

Table - B

Lik field - Product_ID

Display field - Product_Name
Category control - Manufacture_ID

Category field - Manufacture_ID

D
Devon author 11/26/2005

Thank you. That resolved that issue.