makerbert

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

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?

Outcomes