thanks Cetin,

I'll study that.

My data are very simple: parts table (PK -> parts_id) contains all part numbers etc...
BOM table contains parent_id (fk to parts), child_id (fk to parts) and qty (and beginning date and enddate etc.)

Peter