I don't think anyone will be able to answer this. You are asking in your
industry terms, we need to know in database terms. How is your data
structured? What are the realtionships between the tables? If this is a
parent/child report issue, we would need to know how the report and
subreport are structured and related to each other.
Post back and pretend we are computer geeks that don't work in your industry
and have no idea what a BOM is.
Rick B