>Sorry, was away from my desk...
>
>I'm not exactly sure, yet. This is all very much in the design stage. I'm trying to break down different types of tasks. I will have one main table that holds stuff like who the task is assigned to, when it was started on, what its status is.
>
>The child table(s) will be memo fields and characters. If the task is, say, documenting, I may just have a character field saying what I'm documenting. If the task is adding a field to a screen, I'll need stuff like what screen, field name, control source, etc.
>
>Or, I could just have one memo field called "task" and shove it all in there. But I'm trying to get away from the free-form style into specific forms to fill out with different fields for each form.
Hard to give a definitve answer - if there's no rush, a would simply leave both options open for now - you may in fact learn more as design continues which will tilt you more in one direction.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.