qwerty
Posts: 6
|
Posted: 02/25/2004, 9:31 PM |
|
Hello
There are tables which store a task, its related subtask and difficulty levels for each subtask.
Task -- SUBTASK -- Difficulty
subtask1 - 1, Simple, 1
subtask1 - 2, Medium, 2
subtask1 - 3, Hard, 3
subtask2 - 5, Simple, 2
subtask2 - 6, Medium, 3
subtask2 - 7, Hard, 4
subtask2 - 8, Very Hard 5
Now each Task can be made up of these several subtasks and it can be assigned a difficulty level to it.
This is how I want my task record page to appear
Task 1 Dropdown for subtask1, dropdown for subtask2 ... Dropdown for as many subtask listed.
How do I acheive this using CCS ?
Could be for PHP/MySQL or ASP/Access. I guess the logic will be the same.
Any help is appreciated.
Warm Regards
-Qwerty
_________________
There is no place like 127.0.0.1 |
|
|
peterr
Posts: 5971
|
Posted: 02/26/2004, 2:05 PM |
|
Not sure if I understand this fully.
Do you need a dynamic number of drop-downs? Or a dynamic-way of updating specifically 2 or 3 drop-downs?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
qwerty
Posts: 6
|
Posted: 02/26/2004, 8:32 PM |
|
Hi Peter
I need a dynamic number of dropdowns.
Lets see if I can elaborate this better.
I would have a table which lists all the subtasks that can be performed.
Each subtask has many difficulty levels and estimated hours assigned.
(ONE "subtask" related to MANY "difficulty"
ONE "difficultly" relates to ONE "subtask")
So far, no problem. I can populate these records conviniently.
Now each "task" is created of these subtasks.
(ONE "task" is made up of MANY "subtask"
ONE "subtask" is a part of MANY "task")
actaully, each task is made up of each and every subtask defined in the subtask table.
What I want to do is for each task, assign the levels of complexity of those subtask.
Therefore the convinient GUI for this wuold be
Task, Subtask1, Subtask2 ......... Subtask3
Where Task is a textbox.
subtask1, subtask2 ... subtask3 would be dropdowns with the related difficulty levels pulled from the difficulty table.
Hope this helps and you can provide some insight into this.
Thanks and Regards
-Rupen
_________________
There is no place like 127.0.0.1 |
|
|
peterr
Posts: 5971
|
Posted: 02/26/2004, 8:59 PM |
|
I think that the way to do this is to create single label and then use the Before Show event of the label to programmatically retrieve all needed data from the database and create the HTML necessary to display the ListBoxes you need. This basically is a manual programming task. You cam find articles on the net about creating dynamic, dependent listoxes, which you might need to adapt to your needs.
Here are a few examples: http://www.learnasp.com/learn/listdynamicdb.asp http://www.atgconsulting.com/oodynlistbox.asp http://www.visualbasicforum.com/t55739.html
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|