AnsweredAssumed Answered

Many to many relationship choice !

Question asked by traart on Jan 25, 2011
Latest reply on Jan 26, 2011 by traart


Many to many relationship choice !


Hi everyone

I am new in filemaker.

My problem is to create join table.

I have a 

firm table (connected to) product table (connected to) join table (connected to) receiving orders table (which i use with portals)

And i want to create another table which calls "giving orders table" to connect same firm table and product table. But i could not decide to use same join table or not. I am little bit confusing for reporting, maybe reports could not work properly when i used same join table for two separate tables. Because of too many records in it. 

Whats your advice ?

Sorry for my English