Results 1 to 3 of 3

Thread: MS SQL 2000 Phantom Relationship [Resolved]

  1. Nov 29th, 2006, 08:00 AM #1
    señorbadger
    señorbadger is offline

    Thread Starter
    Addicted Member señorbadger's Avatar
    Join Date
    Oct 2003
    Location
    Mud pools of wellingborough
    Posts
    193

    Resolved MS SQL 2000 Phantom Relationship [Resolved]

    This is just a general query, i've got 2 tables in a database that have no relationship to each other

    Project

    Project_UDF

    They both have a field called Project_ID and these 2 fields are the Primary Key of their respective tables.

    When i import them into the query designer or the diagram tool it automatically assumes a link on Project.Project_ID = Project_UDF.Project_ID which is correct but how did it know this?

    Thanking you all in advanced

    Sam
    Last edited by señorbadger; Nov 29th, 2006 at 02:07 PM.
    Reply With Quote Reply With Quote
  2. Nov 29th, 2006, 01:36 PM #2
    Mark Gambo
    Mark Gambo is offline
    Giants World Champs!!!! Mark Gambo's Avatar
    Join Date
    Sep 2003
    Location
    Colorado
    Posts
    2,965

    Re: MS SQL 2000 Phantom Relationship

    Quote Originally Posted by señorbadger
    This is just a general query, i've got 2 tables in a database that have no relationship to each other

    Project

    Project_UDF

    They both have a field called Project_ID and these 2 fields are the Primary Key of their respective tables.

    When i import them into the query designer or the diagram tool it automatically assumes a link on Project.Project_ID = Project_UDF.Project_ID which is correct but how did it know this?

    Thanking you all in advanced

    Sam
    it assumes. Since each table has the same name and both of them are the primary key it assumed that they are related.
    Regards,

    Mark

    Please remember to rate posts! Rate any post you find helpful. Use the link to the left - "Rate this Post". Please use [highlight='vb'] your code goes in here [/highlight] tags when posting code. When a question you asked has been resolved, please go to the top of the original post and click "Thread Tools" then select "Mark Thread Resolved."

    Reply With Quote Reply With Quote
  3. Nov 29th, 2006, 02:04 PM #3
    señorbadger
    señorbadger is offline

    Thread Starter
    Addicted Member señorbadger's Avatar
    Join Date
    Oct 2003
    Location
    Mud pools of wellingborough
    Posts
    193

    Re: MS SQL 2000 Phantom Relationship

    Thanks for that, i had a feeling it was but wanted someone to confirm it
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width