Filter a parameter field by a collection contents
I have modeled four entities:
- Product Development (DesarrollodeProducto) as the main process entity.
- Quotations (Cotizaciones), a collection (one to many) of the Product Development entity.
- Purchases, a master (one to one) of Product Development entity.
- Suppliers, a parameter entity used by both Quotations and Purchases.
In the Quotations collection, I have included a Suppliers field, so every quotation has a related supplier.
Have done the same in the Purchases entity, so every purchase has a related supplier.
I neeed that when a user selects the supplier related to a purchase, the parameter values are filtered to show only those that are already related to a quotation.
In other words, a supplier can only be related with a purchase if it has been previously related to a quotation.
Is it possible? What is the best way to make it work?
Thank you in advance.