Displaying ALL purchase order lines on the purchase order list page

I have a customization that is to display the items on a purchase order in the list page.

Currently they only show 1 item but the users want to have the list page show all the items on that purchase order. They are perfectly fine with seeing the purchase order multiple times. What I have done is added the PurchLine_ItemId, PurchLine_LineNumber and PurchLine_ExternalItemId onto the grid. This only picks up the first item on the order. No code has been written and no queries.

purchtable.JPG

Only changing the grid worked on a similar customization for the Released Products List Page unsure of why it isn’t working for the purchase order.

Added another PurchLine Datasource to the form with an inner join.