Cannot create one to many relationship when working with MySQL through ODBC
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