I'm looking at using Publisher with Data merge in order to make my content and I'm running into a bit of a roadblock with my conceptual understanding of how it works for my context.
I have two types of entities, lets say people and items. There will be a data file for each, say people.csv and items.csv.
Each record in people.csv will correspond to a single page, so that is easy enough and works very well with the data merge manager (can we call it DMM?).
The hard part is that each person can have multiple different items. Ideally I could define all of my items once in items.csv, and specify for each person record which items it has, ie person A has items X,Y,Z. Person B has items W and Z, etc.
I'm stuck on how to use DMM to do this. My best guess right now is doing a two step process of making another document that is purely items. I would use DMM here to generate docs which I would then export. I could then specify in the 'people' csv which item images to merge into each person record. The items could be formatted like table rows.
Is there a better way of doing something like this?