Mysql one to many connection problem
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?