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.