I am putting together a Gridview that will allow us to see what item need to be ordered along with when the expected ship date of that item is.

I have 3 gv files
Items to Purchase (Displays items, qtys in our Whse, Minimum order qty)
Locations (Displays stock levels at different locations)
Back Order Report (When you double click on an item in items to purchase this will show the customers that have that item on order as well as the expected ship date)

What I want to do is have the expected ship date appear in the Items to Purchase window, showing the oldest date.

How do I do this?