We have a relationship in FM 16 with a SQL.
When we add the same table from T12_PRODUCTEN and make a relation with the SQL with the Primary Key 'id' as the relation, it wil not work.
If We make a connection again from the table T12_PRODUCTEN to T12_PRODUCTEN 2 with the relation 'id', everything works fine.
Is this a bug in FileMaker, that you can add the same table and use it for a SQL connection?
With kind regards,