View Single Post
 
Old 12-09-2015, 10:09 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

OK, so you have -

Quote:
Originally Posted by AndyS View Post
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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote