Discussions

Expand all | Collapse all

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

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

    Posted 09-19-2018 17:55
    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.


  • 2.  RE: How do I create a BOM for an assembly that relates to Part#s

    Posted 09-19-2018 17:59
    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.