Field Editor: Dependent Lookup Filter

Josef,

I think I”ve found a way to do what you want. I’ll describe it to you in terms of your objects but the screenshots are where I did the same thing for the Task object, using WhoId and WhatId (contacts and opportunities so I could take advantage of the OpportunityContactRole object as the junction object to limit contacts based on the opportunity chosen). In this case opportunities are analogous to system type and contacts are analogous to vendor.

First, add a model for the VendorSystemType junction object to your page. It only needs to include its own Id and the VendorId and SystemTypeId relationship fields. Add a filterable default off condition on it for the SystemTypeId field:

Next, add an action to your custom Account model. The action should be initiated by row in model updated, and specifically when the SystemTypeId field is updated:

The action to take is “Activate and Set value of model condition” on the junction model. Set the SystemTypeId condition on it to be something like {{SystemTypeId}}. You’re using merge syntax to pull the value of the SystemType field from the account object’s current row (I was pulling the Opportunity Id which was stored in WhatId for tasks). You also need a second action - query the junction model:

The last step is to add a filter on the Vendor field on the field editor for the account object. The filter should say that the Id (the Vendor Id, since we’re looking at the Vendor object through the relationship) is in the VendorId from the junction model. You can get to the Filters section by clicking on the field in the field editor, and then clicking the Filters section:

the filter setup:

Once you’ve got all this setup, the flow should be: you pick a System Type and that triggers the action to set the condition on and query the junction object. Then, because the Vendor field is filtered to only show results from the junction object it updates and you only see Vendors that are connected to the System Type.

Hope this works out for you!