Hi can someone please tell me the basics or point me to an article for
merging repeating data

I have a database of awards (student achievements) , each record has 0
or more related units.

I need to merge the data in word so that each award is a single
document with a repeating area in the middle listing the units.

I could possibly use a pivot table and a fixed max number of units to
get the data, but would prefer to retrieve the data like this:

AwardID Unit
1 1
1 2
1 17
2 16
3 31

What are the basics for handling this kind ofr merge?
Thanks
hals_left