Forum Discussion

DavidBrogdon1's avatar
DavidBrogdon1
Qrew Trainee
6 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 rel...
Relationships
Tables and fields
ChrisChris's avatar
ChrisChris
Qrew Assistant Captain
6 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.