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.