Thomas,
Thanks.
I have heard of xcase and heard it is great. Haven't ever yet had time to check it out. It's on my list to do. If it helps me visualize what I am trying to accomplish that will be great.. because in this case I'm thinking there must be a 'standard' way to do something like this.. i.e. a standard methodology, or most efficient approach, but I don't know what that is.. maybe the tool will help me figure it out on my own.
For now I am starting to write code based upon the example I gave and trying to figure out if I have the right data structure to do what I want. I will write back when I've fleshed it out a little further.
>David;
>
>My favorite tool to use for database development is xCase.
>
>
http://fox.wikis.com/wc.dll?Wiki~xCase~SoftwareEng>
>
>I find that it really helps to visualize what tables are used and their relationships.
>
>Tom