Results 1 to 3 of 3
Thread: Which to do?
Apr 13, 2002, 21:24 #1
- Join Date
- Oct 2001
- Whistler BC originally from Guelph Ontario
- 0 Post(s)
- 0 Thread(s)
Which to do?
Well I have a dilema. I have created a task/project manager and have just been asked to add a feature. As far as I can see I have two choices. (really I should have thought of this when I started but i didn't come to mind)
I have a current table
Now I think I can do two things
1 - create a lookup table and simple add an option to create recursive tasks. This means there would be no changing the original table. Simply adding a new table with a foreign key to the recursive rules.
2 - Add another column to the original table connecting it to the Recursive table detailing the rules.
Now for all legitimate purposes I don't really need the lookup (my boss doesn't require future editing of the tasks as of yet) but I am trying to make it so when the time comes and he wants to edit when how or where the recursive tasks fall there is a table tracking the proper information which can then edit the appropiatr tasks.
So I am wondering what others would do in a situation like this. Which would seem the best option?