i have a business case, based on 4 custom modules. The products can be placed on a depot/warehouse but, optionally, we can specify the location inside the depot, and the bin. I created the following relationships:
Account *1toM* Warehouse *1toM* Locations *1toM* Bins *1toM* Products
Warehouse *1toM* Products
Account *1toM* Products
I want to see in "Warehouse" the products products related to bins and locations related to the warehouse.
Is there a simple way to keep align the relationship between products, warehouse and account?