4 Replies Latest reply on Nov 25, 2014 4:30 AM by Mike_Mitchell

    one to many automagically changed in many to many

    makerbert

      Hi,

       

      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?

       

      too_many.jpg

       

      Now what do I do wrong?