This topic is locked

Dynamic Drop down table structure

8/31/2007 9:06:56 AM
ASPRunnerPro General questions
S
stealthwifi author

Hello,
I have create a table to store data for a set of dynamic drops downs.
The drops downs depend on the drop down LOB which will be either Auto, GL, Prop, or WC
There are 5 drop downs (each containing diffrent info that will depend on LOB) they are:
Part

Type

Cause

Source

Event
I have written html code that handles this well but it sucks to go into the prograimgn to add criteria for the drop downs.

I have created a table in another project that does basicly the same thing but it is very hard to look at to update criteria in using the Add page with Asp Runner.
My question is what is the recomended table structure for this set up?

In my other project I had the table set up like this (this is all Microsoft SQL)
Table name: Criteria

Primary Key: CriteriaID (int auto number)

LOB (varchar 10)

Part (varchar 40)

Type (varchar 40)

Cause (varchar 40)

Source (varchar 40)

Event (varchar 40)
Cheers,

Stealth-

Sergey Kornilov admin 8/31/2007

What are dynamic dropdowns?

S
stealthwifi author 10/10/2007

I am sorry i meant dependent drop downs. There are 5 seprate dropdowns and all are dependent on the WC drop drop down.

I have played with table structure as to what will be the easiest to add to and edit for our users. Any suggestions?

Sergey Kornilov admin 10/11/2007

This database structure will work if all dropdowns belong to the same lookup table.