I am using Sharepoint Server 2007, Microsoft Word 2007, Windows XP SP3, and Sharepoint Designer 2007. We are upgraded to Sharepoint Server 2010, Office 2010, and Windows 7 in 3 weeks.
I have a Sharepoint 2007 custom list named Courses with several fields. One of the fields is Modules.
I also have a custom list named Modules with several fields with details for each module.
Courses.Modules is a lookup field that allows multiple selections from the Modules Table (it points specifically to the Modules.Title field).
Currently, I have a workflow that creates a new Word 2007 document (.docx) in a Sharepoint Document library (named Course Outlines).
The workflow works perfectly, and populates my document with all of the fields from a specific item within the Courses list.
What I would like to do is have it create a single word document that consists of the Course Outline (as it currently does perfectly), and then appends to that word document an outline of each module (details pulled from the Modules list).
For redundancy's sake, there is a field in Modules named Course Number that corresponds to a field in Courses also named Course Number.
I can either relate the Courses list to the Modules list using the Coures.Modules field (which should contain multiple Modules.Title), or I can relate C*ourses* to Modules by using the Course Number field of both lists.