How do I create a BOM for an assembly that relates to Part#s

  • 0
  • 1
  • Question
  • Updated 10 months ago
  • In Progress
I have [Assemblies] and [Parts], I need each assembly to have a list of parts that it requires, but I also need to be able to relate each part to multiple assemblies. I know this will be a reverse relationship situation, but I'm struggling with how to get it done. Can anyone offer a breakdown for me? 

Photo of David Brogdon

David Brogdon

  • 192 Points 100 badge 2x thumb

Posted 10 months ago

  • 0
  • 1
Photo of Chris


  • 4,430 Points 4k badge 2x thumb
It's actually best in this case to create a many to many relationship using three tables: Assemblies, Parts, Details.

Assemblies >> has many >> Details
Parts >> has many >> Details

Through this set up, you can relate each Part to multiple Assemblies and each Assembly to multiple Parts. Your Details table will serve as the BOM.