Hi
I deal with BOMs and this is how I handle them.....
Basically a BOM can contain other BOMs and a recursive method is required..i.e. calls itself.
This method enters data into a temp table that contains a parent material and its children
Sub BOMMethod(rst As DAO.Recordset, strAssembly As...