Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Relation

forums › forums › SQLyog › Using SQLyog › Relation

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • May 18, 2005 at 6:57 am #8984
      sonamom
      Member

      Hello everyone, i have been using SQLyog for a week now and its great…

      very comfortable . I got all my tables created in a giffy..

      now my problem is i can't manage the relation..

      here is the problem.

      I have a Table called “Personal Details”

      which stores the informations about a person.

      And now there is another Tables called “Name” which will store the First_name, Second_Name and the last_name.

      Now i want to link the 2 table using a “Foregn key” called “Name_id”

      but i couldn't do it. I went into Manage Indexes and made Name_id field in “Personal Details” a foreign key.

      its not working can u help me?

      somebody! anybody!

      sonam

    • May 18, 2005 at 11:31 am #17830
      Shadow
      Member

      First: not all table types (now referred to as engines) support relationships! Second: there is a separate relationship manager in SQLyog (F10 is its hotkey), use that one instead of manage indexes feature.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.