one to many automagically changed in many to many

Discussion created by makerbert on Nov 25, 2014
Latest reply on Nov 25, 2014 by Mike_Mitchell



This is my first filemaker project but I'm confident setting up and using databases, mainly ms-sql but done oracle as well.


I have set up a simple order system having customers, products ,orders and order details,

I also defined one-to-many relations between the tables. not exactly rocket science. I changed the ID fields to text, calculated, to use GET ( UUID) and those fields are all | Auto-enter Calculation, can't modify auto"


now I'm dabbling in some layout views and suddenly I see all my relationships are changed tot many-to-many, how is that possible?




Now what do I do wrong?