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

asked 11 Sep '13, 12:51

mfkpie8's gravatar image

mfkpie8
80444853
accept rate: 9%

closed 13 Sep '13, 13:55

Graeme%20Perrow's gravatar image

Graeme Perrow
8.7k374112

Does that sample from the docs help - it seems rather similar:

Parts explosion problem

(11 Sep '13, 15:37) Volker Barth

The question has been closed for the following reason "It is unclear what is being asked." by Graeme Perrow 13 Sep '13, 13:55

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×17

question asked: 11 Sep '13, 12:51

question was seen: 525 times

last updated: 13 Sep '13, 13:55