Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Recursive relationship queries

Recursive relationship queries

Recursive relationship queries

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?

RE: Recursive relationship queries

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.

RE: Recursive relationship queries

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?  

RE: Recursive relationship queries

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,

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close