cancel
Showing results for 
Search instead for 
Did you mean: 

BOM with car !Want to know how many car accessories

ximen
Participant
0 Kudos
1,431
 1. a.  Product engineering table

BOM_table_master
ID name EMger
001 cars
002 002 engine parts
003 003 chassis parts
003.1 003.1 sensor components
003.2.1 connector accessories 003.2.1
        BOM query recursive query if an order has several products should be
    how to query

    BOM_Detail_part
        ID name parent_BOM
        001 002 engine parts
        001 003 chassis parts
        004 engine cover 001
        002.01 cylinder block of 002
        002.02 piston ring of 002
        002.03 piston driving arm of 002
        002.04 inlet pipe of 002
        003.1 sensor parts of 003
        003.2.1 connector accessories, 003
        003.2.2 solid 003 pieces
        003.1.1 ABS induction line of 003.1
        Allen 003.2.1 003.2.1.1 fasteners

Accepted Solutions (0)

Answers (0)