AnsweredAssumed Answered

Mysql one to many connection problem

Question asked by MennoPleij on Oct 25, 2013
Latest reply on Nov 2, 2013 by MennoPleij

Title

Mysql one to many connection problem

Post

     Hello,

     We're thinking of using FMP 12 for a management front-end for a specific web service we're developing, but now we're encountering a strange problem which can be seen in the attached screenshot. When using a mysql database we can see everything (explore the database) but the moment we try to make a relationship between two tables only a one-to-one connection is possible.

      

     As you can see we've done a small test where we mimicked the database with a FMP version, which did allowed us to make a one to many connection. Is this a bug or a known limitation? In the last case the whole implementation of mysql is useless anyway is it?

Screenshot_one_to_many_problem.jpg

Outcomes