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-