I am working on exporting PO_details through an ODBC in Access, teaching myself as I go. My query is close to what I want but, I need to find the table for the distribution of the "LineKey". In SO they have a table SO_SalesOrderTierDistribution, in the PO tables they have a couple tier tables but not one for the detail, I don't see any PO table where I can make the relationship. The SO "linekey" breaks down one line into the different size and colors to create a different record/row. I attached a screen shot of my SO export.so tier.pdf