Constrain Parent Child

I am very new to Mendix and trying to get an app working before committing to a purchase. I have a simple parent / child relationship, in my case Locations and Equipment. Equipment has associations to Product, which is associated with Manufacture. From a page with Location List, I would like to have a button that opens a page that shows some location data and all the equipment located for the location. I have everything working, I just can’t figure out how to get the Equipment table constrained to a specific location. I can do it with a microflow, however I would like to be able to do onscreen editing on the equipment. Hopefully this makes sense   Thanks Martin  
2 answers

Can you show us a screenshot of your domain model?


Here is a simplified version, with a few extra elements.

Storage is Location.

I was able to get it to work by making sure the list was in the correct data view, however in doing so I lost access to the Manufacturer and Product Series. To work around this, I denormalized the database.

I keep thinking there should be an easier way.