Using a Portal to retreive data more than two hops away
We are trying to set up a Filemaker database controlling component usage/purchasing within a small manufacturing company. The “products” we sell are assembled from “components” and we have the following tables:
“Orders” linked using a “many to many” relationship with “products” which in turn is linked with a “many to many” relationship with “components”.
We want to create a portal that will show all the “orders” that require a certain component. We can easily set up a portal within a layout based on the "component" table that looks two hops away to "products" but can’t get the information we require that is more than two hops away.
Is this something Filemaker can’t do or have we got the relationships wrong or something else. Any help would be gratefully received…many thanks in advance.