I have these two entities who are related (one order: multiple products):
Owner (Values come from the Owners entity, based on the Facility)
ProductType (I need these values to be filtered based on the facility from Order entity)
I created a model driven app and it works great; however how can i filter the ProductType values based on the Facility choosen?
I can filter the owner values based on facility because they are part of the same entity (using the related records filtering property of the field); but the ProductType is in a different entity than the Facility field; how can i filter values to create a casacde dropdown?
I have been experimenting with Model driven apps for a few months but I am not an expert. I don't believe that you can use cascading dropdowns. However, you can use a Subgrid on a form to show related items in a different entity as long as the child entity (Products) uses a many to one relationship to the parent (Orders).