I've looked at the Microsoft Word Catalogue/Directory Mailmerge Tutorial already. I'm not sure that I can go that way, though, because I have two records that I am working out of then. My database only pulls out one at a time, although I can reference other records that have a parental relationship to the record I'm working out of, too. I would have to pull out the person records and then the award records, and then somehow match them back up, right? That's why I store the records in the clumsy field.



Here is the end goal: I have a letter that has fields drawing from the person record in its body. I then have a spot that has a table. This table has the other record, the awards. I don't have many options of pulling them both out at the same time, although I do have the ability to customize the system.
Am I overthinking this?