How do you create a multi level BOM data base?

[SadCrow]

Hello everyone,

I have to make a parts list that consists of several assemblies (see example in the picture). Now it's a matter of making the database for this so that I can allocate the components to an assembly. So that in the end I program a search function in VBA with which I can query an assembly and then see what this assembly consists of. For example, if I search for B2, then all components that follow in the family tree (B1 (T1 and T2), T1, T2) must be displayed so that the buyer knows which material he needs. Now I don't know which table form is best suited to create a database with this structure. I would be happy if you give me a few suggestions on what works best. Thank you very much.

gozinto_03_en.png

[CK76]

Preferably, I'd do this in true relational db (MySQL, MariaDB, SQL, etc).
This sort thing is best kept out of Excel. While it isn't impossible, it will be difficult to maintain and may quickly get out of hand.

You can use adjacency list data structure to accomplish your need.

Have a read of...
https://www.sqlservercentral.com/art...to-nested-sets
https://www.sqlservercentral.com/art...calculations-1
https://en.wikipedia.org/wiki/Hierar...database_model

EDIT: To be clear. Creating database/table for multilevel BOM isn't hard to do in Excel. But crux of the problem is how you retrieve the data and hierarchy efficiently.

[CK76]

Oh, if you don't want to re-invent the wheel.

Something like below may suite your need.
https://www.odoo.com/app/manufacturing

Odoo offers free tier for single app. I've not used their MRP, but have used their PoS for small retailer.