Skip to Content
0
Former Member
Nov 02, 2010 at 01:25 PM

Production ORder Query

75 Views

Can anyone tell me how to link the production order (OWOR) table and the Item Mast Data Table (OITM) I basically want to write a query that shows any production orders that have a certain Sales Order. This query needs to show the item number of the production order, the item description (pulled through from the item master data when they are joined!) and the status of the order, along with the customer data?

Thanks

Steve