Many to many relationship choice !
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