Recursive relationship queries

[tdgulbra]

We have a table, let's call it Parts. A part can consist of base parts or other assembled parts. These assembled parts are also in the Parts table. There is an indicator as to whether the component is a base part or an assembled part. Assembled parts can have different base parts over time. The table also has effective and expiration dates to indicate when a particular assembly is valid.

The question is: How can I get MSI (7.1.3) to process this relationship?

 

[nlim]

good question. What type of report do you really need to generate? inventory by parts? Also do your parts have categories?

Also after you get this report (somehow), what do you want to do with it? Drilling?

The way to process this type of relationship is to identify the distinct requirements first. I'll elaborate after your answers.

 

[tdgulbra]

I need to know what the exact part mix is for a given parent part on a given day. In other words, what child parts participate to create the parent part. Since that mix can change over time, I need to be able to identify it by individual days (dates).

Is that enough?

 

[tdgulbra]

Sorry, I just realized I didn't answer all the questions.

No, there are no categories. I don't see needing to drill beyond the breakdown I mentioned above. The user will probably want to see the top level and then, perhaps, drill down to the component level.

Thanks for your help,
Tony