Script for Combining Value Lists for Task Report
I currently have a layout (Work in Process) where each record shows two types of tasks using separate value lists(production and file processing). The production and fie processing task is selected and then the employee who is responsible for these tasks (again using two separate value lists) is selected. Some notes using edit box fields are also used.
I need to have these tasks put onto another form for "scheduling". The production or file processing employee would be able to see all their tasks on a separate page.
What would be the best way for me to create the new task layout?