I have one table that shows individual printing jobs and another table that shows the ink for each job. There can be as many as 10 different inks for a single job. The field that connects them is ITEM_CODE, which is in itself a unique number. My output needs to have a single row for each job number, which works fine with the format from the JOB table, but the REQ table has a record for each ink. I'm trying to figure out how to get each ink name into a field in one row of my output. Any help would be greatly appreciated!