Good evening all,
I am collecting information from a categorized view by manager name which lists the folks that report to that manager. Each manager has a different number of people working for them. I'd like to show the information from that view in a form that has the manager's name at the top, of course, and then the people that report to him, each on their name on a line with a few checkboxes to the right of their name. How can I do this especially since the number of people would be dynamic. For example:
Manager: Joe Something
Class 1 Class2 Class3
Jane Someone chkbox here chkbox here chkbox here
Bob So & so chkbox here chkbox here chkbox here
It'll give the manager a place to note whether or not a class was taken. Being able to include the date the class was taken would be a bonus (either below or to the right of the checkbox). I believe that I will need to deal with arrays, redim preserves, etc. I've been trying to figure out how to do it and have been able only to get a checkbox next to the name of the reports and having only the one column. Creating tables rows and fields as needed? Profile documents? My brain is going around and around. Can it even be done? What am I missing? Argh! I just thought of something ... there may be a different number of classes each year. Let's just deal with that dimension later. Let's just assume 3 classes for now. Thank you for your suggestions and help.
I am, as ever, in learning awe - Notes Rookie (on R6.5)