5 Replies Latest reply on Feb 19, 2011 10:50 AM by yiger

    Cannot create one to many relationship when working with MySQL through ODBC

    yiger

      Title

      Cannot create one to many relationship when working with MySQL through ODBC

      Post

      Hi,

      I have created a simple database of persons and their addresses. I took as a template the Contacts starter database.

      Then I replaced the FM tables with MySQL tables. But FM won't create the right relationship: i.e. one to many.

      No matter how I define the PK and FK in MySQL, FM always create a one to one relationship (the connection line in the ERD end with T ending, and not "craw foot",as it should).

      Any help would be very much appreciated