I want to create a lists within lists (nested merges)

macropod · #8 12-09-2015, 10:09 PM

OK, so you have -

Quote:

Originally Posted by AndyS

Tables:

Object: entry per artwork with fields like: artist, title, materials and measurements; keyed with an object_id.
Exhibition: name, catalogue reference; keyed with a short name (acronym) as exhibition_id
Location: name of a location at which exhibitions are held; keyed with a short name (acronym) as location_id.
Object-Exhibition: object_id, exhibition_id, catalogue number. Indicates which works appeared at each exhibition.
Exhibition-location: exhibition_id, location_id, start date, end date. Indicates which exhibitions were held at each location.

Your mailmerge would be keyed to, say, the Object table. That gives you access to the object_id, which you can use in the DATABASE field to query the Object-Exhibition table and, using the exhibition_id there, to query the Exhibition table and the Exhibition-location table and, via the location_id there, the Location table.

Although the DATABASE field outputs its results as a table, you could reformat the table or throw it away (just keeping the data) afterwards. And, depending on your requirements, you could have multiple DATABASE fields, with their own outputs for each record returned from the Object table.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cant create any more numbered lists.	rapid3642	Word	9	11-14-2014 08:28 PM
Need Serious Help with Outlines/Lists	Stone	Word	5	09-11-2012 04:56 PM
Numbered Lists	jburtis	Word	1	04-07-2012 02:42 PM
Distribution Lists	WildBill	Outlook	2	08-11-2011 08:15 AM
Searching dates to create lists	brianh	Excel	2	01-18-2010 01:58 PM