Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Apr 2004
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    parent/Child/Job number Relationship (Excell 2000)

    Ok, I'm pretty sure I posted this before but I cannot find the results.

    I have three columns:

    Column F: = Job Number
    Column H: = Parent
    column I: = Child & Parent (Could be both)

    What I'm trying to do is to show the user what other job might be using a said part that he is also looking for.

    Lets say a user (Jane) comes in and clicks on the Column I, looking for part number PR-05399.
    She needs to know if a previous order needs the same part number, because that order gets precidence first.

    I need to be able to hyperlink that child number to the parent number but I also need to know if there are any other childs out there that may need to use it as well.

    plus the user needs to know what job is using it.

    They also need to be able to Hyperlink to the previous job that uses it, if they desire to

    I have attached a small portion of the spreedsheet please review.

    Sorry But I'm totally confused, and Lost.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: parent/Child/Job number Relationship (Excell 2

    Was it this <post:=556,450>post 556,450</post:>?
    Jerry

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: parent/Child/Job number Relationship (Excell 2000)

    Is this the thread you are looking for?

    <post:=556,450>post 556,450</post:>
    Legare Coleman

  4. #4
    2 Star Lounger
    Join Date
    Apr 2004
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: parent/Child/Job number Relationship (Excell 2000)

    Hi Legare & Jezza yes it was that post but I'm not sure I understand it. could you please explain it in english. I'm still a newbie and still learning excel and VB. The more and more i get exposed to it the more and more people are using different terms which confuse me. Please assist.

    I hate to beg, but this is THE best site out there on the internet and I hate dealing with other newbie's who think they know the answer to the question when they don't really understand the question.
    thats what I've been getting on other sites. I come here and BAM! done. just like that.

    Thank you

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: parent/Child/Job number Relationship (Excell 2000)

    What don't you understand? Could you post specific questions in the original thread?
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •