DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: "Same Parent cannot be parent for 2 child tables"

Hybrid View

  1. #1
    Vince Teachout Guest

    "Same Parent cannot be parent for 2 child tables"

    "The Same Parent cannot be parent for 2 child tables" - Why the ****
    NOT?!!!

    I have a table with User ID, Division code field.

    When I try and run the query wizard to select the User name and
    division name from 2 other tables, using the fields as look ups into
    those tables, I get the above error message.

    Obviously, it's no problem doing this with SET RELATION, why should it
    be a problem in SQL?

    Is this a SQL limitation? A Wizard bug? Is there actually a good
    reason why this isn't allowed? I'm coding around it for now, but this
    is annoying. Any suggestions? (Other than telling me to lay off the
    coffee....)

    Ignore munged e-mail address above.
    If necessary to reply via e-mail, please reply to:
    caracal A T caracal D O T net

  2. #2
    Stephen Russell Guest

    Re: "Same Parent cannot be parent for 2 child tables"

    I don't have this problem with my queries or views. I'd stop using the M$
    tool and code them by hand.

    __Stephen

    "Vince Teachout" <SendJunkMailTo@hotmail.com> wrote in message
    news:d07g0to4sqdmrm066g60pdbk8ikvddrugj@4ax.com...
    > "The Same Parent cannot be parent for 2 child tables" - Why the ****
    > NOT?!!!
    >
    > I have a table with User ID, Division code field.
    >
    > When I try and run the query wizard to select the User name and
    > division name from 2 other tables, using the fields as look ups into
    > those tables, I get the above error message.
    >
    > Obviously, it's no problem doing this with SET RELATION, why should it
    > be a problem in SQL?
    >
    > Is this a SQL limitation? A Wizard bug? Is there actually a good
    > reason why this isn't allowed? I'm coding around it for now, but this
    > is annoying. Any suggestions? (Other than telling me to lay off the
    > coffee....)
    >
    > Ignore munged e-mail address above.
    > If necessary to reply via e-mail, please reply to:
    > caracal A T caracal D O T net




  3. #3
    Cindy Winegarden Guest

    Re: "Same Parent cannot be parent for 2 child tables"

    Wizards are by nature for "simple" needs only.

    --


    Cindy Winegarden

    Microsoft Certified Professional, Visual FoxPro
    Microsoft Visual FoxPro MVP

    cindy.winegarden@mvps.org



    "Vince Teachout" <SendJunkMailTo@hotmail.com> wrote in message
    news:d07g0to4sqdmrm066g60pdbk8ikvddrugj@4ax.com...
    | "The Same Parent cannot be parent for 2 child tables" - Why the ****
    | NOT?!!!
    |
    | I have a table with User ID, Division code field.
    |
    | When I try and run the query wizard to select the User name and
    | division name from 2 other tables, using the fields as look ups into
    | those tables, I get the above error message.
    |
    | Obviously, it's no problem doing this with SET RELATION, why should it
    | be a problem in SQL?
    |
    | Is this a SQL limitation? A Wizard bug? Is there actually a good
    | reason why this isn't allowed? I'm coding around it for now, but this
    | is annoying. Any suggestions? (Other than telling me to lay off the
    | coffee....)
    |
    | Ignore munged e-mail address above.
    | If necessary to reply via e-mail, please reply to:
    | caracal A T caracal D O T net



  4. #4
    Vince Teachout Guest

    Re: "Same Parent cannot be parent for 2 child tables"

    Ok, so it's a Wizard limitation. Good. (I was able to do it by hand
    without a problem). It's just frustrating to pick out the 40 or so
    fields out of several files, and THEN be told it can't be done....



    Ignore munged e-mail address above.
    If necessary to reply via e-mail, please reply to:
    caracal A T caracal D O T net

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center