S
Smaug
I would like to create a database for parts and assemblies of parts (Bill of
Materials). Assemlbies would consist of parts and other assemblies which
would also contain parts. The database should also allow for multiple levels
of assemblies. For example:
Assembly-A
Assembly-B
Part-A
Part-B
Assembly-C
Part-A
Part-D
Assembly-D
Assembly-A
Part-B
What type of table and relationship structure could I use to accomplish
this? How can I create a report to show the hierarchial structure?
Materials). Assemlbies would consist of parts and other assemblies which
would also contain parts. The database should also allow for multiple levels
of assemblies. For example:
Assembly-A
Assembly-B
Part-A
Part-B
Assembly-C
Part-A
Part-D
Assembly-D
Assembly-A
Part-B
What type of table and relationship structure could I use to accomplish
this? How can I create a report to show the hierarchial structure?