ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents
DrillDown Icon MX
DrillDown Icon MANUALS and Other Info for SQL MANEX Client Server
DrillDown Icon Customer Relationship Management (CRM)
DrillDown Icon ManEx Minute
DrillDown Icon ManEx Component Exchange
DrillDown Icon ManEx Supplier Directory & Rankings
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
ICM Query - Link to where PN# is used on BOM

If you are looking to link the part number from ICM to where it is used on BOM It starts with the Bom_det table. In this table, the Uniq_key is the component, the BOMParent is the assembly (both uniq_keys). But this info will only give you one level up.  So you should be able to link the bomparent key back to the inventor table to get the assembly part number. 

Article ID: 3168