I would like to write a query that shows the BoM routing for a BoM. I have the following query that displays the needed BoM details, but it only shows ITEMS, not the Routing steps.
Is there a table that links the Route with the BoM?
I know the user can just look at the BoM to see this, I am going to add more fields/tables to create a BoM report, I am keeping t simple for this question.
SELECT T0.Code AS 'BOM Code', T2.ItemName AS 'BOM Name', T1.VisOrder, T1.Code AS 'Component Item Code', OITM.ItemName AS [Component Name] FROM OITT AS T0 INNER JOIN OITM AS T2 ON T0.Code = T2.ItemCode INNER JOIN ITT1 AS T1 ON T0.Code = T1.Father INNER JOIN OITM ON T1.Code = OITM.ItemCode WHERE (T0.Code = [%0]) ORDER BY T1.VisOrder