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?