AnsweredAssumed Answered

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

Question asked by yiger on Feb 18, 2011
Latest reply on Feb 19, 2011 by 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

Outcomes