Results 1 to 3 of 3

Thread: MS SQL 2000 Phantom Relationship [Resolved]

Threaded View

  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
« 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