Forum Discussion

DavidBrogdon1's avatar
DavidBrogdon1
Qrew Trainee
7 years ago

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

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.
Relationships
Tables and fields
  • ChrisChris's avatar
    ChrisChris
    Qrew Assistant Captain
    7 years ago
    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.