2. PHPRunner General questions
  3. dependent dropdown boxes
This topic is locked

dependent dropdown boxes

 		11/26/2005 11:36:05 AM
PHPRunner General questions
S
 scy author

Hi
I am having trouble trying to get a dependent dropdown box to work. I have read yesterdays post on the same subject. It is not so much PHP runner but the database Tables structure necessary to achieve this.
In a simple example I have one main table A with vairous fields. and another B with a list of categories.
That is straight forward enough. I get stuck trying to add a dependent list of sub-categories.
Do these need to be in a new seperate table or within table A or B?
Sergey Kornilov admin 11/28/2005

Hi,
sure, you need a field or a table with sub-categories if you want to use them.
However it's not clear what you need to achieve.

Please give more detailed description of your task.
S
 		scy author 11/28/2005

At this stage I am just trying an example to see how this works. I will then integrate it to an existing database.
Suppose I have a table with data that I wish to organise into Categories and Subcategories.

I could have one table with fields for categories and subcategories ENUM type and list all the categories in the lookup wizard.
or use the lookup table option.
I have made a separate table for categories which works fine. When I try to add a sub categories table the category control field in the lookup wizard only shows the original main table. How can I get to the subcategory table or should the subcategories be listed ENUM type in the main table?
Sergey Kornilov admin 11/29/2005

Hi,
dependent lookups work with table lookups only.

So you need to store catgories and subcategories in one or two separate lookup tables.
S
 		scy author 11/29/2005

Thanks for your help. I seem to have got it working now.