Skip to main content
Question

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

  • September 19, 2018
  • 0 replies
  • 44 views
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? 

Thanks.
    This topic has been closed for replies.

    • ChrisChris
    • Registered
    • September 19, 2018
    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.


    Terms & ConditionsAccessibility statement