The attached EXCEL table (Sheet1) is a “flattened” version of a relational database. This would normally be generated as a query from the actual database, which is currently an EXCEL workbook, but this one was made by hand for test purposes to avoid being distracted by the details of the database.



I want to generate a WORD document with a section (new page) for each Object. (An Object is a work of art, drawing, painting, sculpture etc). At the top of the section is the fixed singular data for the object: Artist, Title, Year, Dimensions and Materials.

Then there is a section headed Exhibitions, which lists all the Exhibitions (if any) in which the Object has appeared, in chronological order of (first) Start date, giving the name of the Exhibition and the Catalogue_nr of this Object at that Exhibition. If the Object has never been exhibited then the text “No exhibition record” should be entered instead.

For each Exhibition there is a list of Locations with Start and End dates, in chronological order of Start date. There will often only be one Location, but touring exhibitions can have several. The first one should appear on the same line as the Exhibition details, and others on subsequent lines with blanks or ditto marks for the Exhibition details.

The attached WORD file is a start, but not complete.

The rules are:

• Object_id is a unique identifier (key) for Object. Artist, Year, Title, Dimensions and Materials are attributes of Object. These are not unique over the table as a whole (distinct Objects could be called “Untitled” and have the same Date, Materials and Dimensions).
• An Object may appear in zero or more Exhibitions. Exhibition_id is a unique identifier for Exhibition, in case two distinct exhibitions have the same name.
• More than one of our Objects may appear in the same Exhibition. They each have a Catalogue_nr, which is unique for the Object at that Exhibition (there is no requirement to check this).
• An Exhibition takes place at one or more Locations (there should be an error message if there is no Location data). Location_id is a unique identifier for the Location, in case the names are the same (though that is unlikely). The Start and End dates define the relationship between Exhibition and Location. (Dates would not overlap, but there is no requirement to check this).

Who can rise to this challenge and show me how to make this simple example work on my computer, with Mac OS X 10.11.1 and Microsoft Office for Mac 2011 version 14.5.8?

Attached Files

	Catalogue mailmerge test data.xlsx (86.6 KB, 20 views)
	Catalogue mailmerge test master.doc (33.5 KB, 21 views)