I have created tables before and used joins but now I would like to expand on that a bit.
I am trying to develop a Parts DB. It has a "tblParts", "tblRequired_items" (to make the parts), and "tblRaw_materials" table (to make the items).
A Part my require another Part and/or "Required Items" to make it.
Some of the "Required Items" may need other "Required Items" and/or "Raw Materials" to make it.
From what I understand, I am suppose to have intermediate tables. Is that correct?
How do I insert data into all those tables?
How do I query those tables? Example: How would I query to see what "required items" and/or "raw materials" make up a part?