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

RELATIONS

forums › forums › SQLyog › Using SQLyog › RELATIONS

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • June 8, 2003 at 4:21 pm #8022
      emari
      Member

      I want to relate two tables:names and addresses both linked by the primary key of the first and the same field on the other table not being a primary key .I cannot do a relation from names to addresses but yes from addresses to names ¿why?. I need it so as if a delete a name I want to delete at the same time related fields on other tables.¿Which is the way to do things well? Thanks

    • June 9, 2003 at 3:16 am #14484
      CalEvans
      Member

      Can't do it.

      You need to build a foreign key in the second table that is the primary key of the first. THEN you can build the relation and add the cascading delete.

      =C=

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