AnsweredAssumed Answered

Many To Many Relationships, Advice Needed!

Question asked by ezellkendrick on Oct 14, 2014
Latest reply on Oct 15, 2014 by ezellkendrick


Many To Many Relationships, Advice Needed!


How does Filemaker know when to make a relationship Many To Many? Does it compare the field names in one table to the other? I am trying to avoid this but don't know how it makes that determination.

I am finding that in some of my data comparisons I can't get away from Many To Many relationships. In these instances, I am comparing data in one table to another table, and I do not want a join table because I would then need to enter data to create records for comparison. Unless there is another way since it seems Many to Many Relationships in Database design are frowned upon. 

Please Advise.