I've got a list in WSS 3.0 documenting work tasks by position that has a bunch of repeating fields such as Task1, Equipment1, Controls1, Task2, Equipment2, Controls2, Task3, Equipment3, Controls3, etc, etc. All in all, it's around 50 fields, but this number could be going up soon to about 90 to 100 because there might not be enough room to accommodate the number of work tasks for some positions.
What I'd love to do is head that off and normalize this a little by putting the repeating fields in their own list and then be able to add and edit those items in the New and Edit forms of the parent list, kind of like an Access form with a subform. I would like to allow the user to create as many or as few work tasks as are actually required for the position being documented.
I've got SharePoint designer, but not VS.