Here is a stab at an example page that I hope is close enough to your situation that it can be helpful.
I’m using the AccountContactRole
object that has lookups both to Account and Contact.
In the form to create a new ACR Record i’ve added a filter on the Contact field that only retrieves contacts that have the Account that has previously been identified for the ACR. (This is probably not very realistic - but its what the data model allowed). The key is using the “Lookup filter” on the Contact field of the type “Another field on row”
I’ve also added an enable condition so you can’t choose the Contact until the Account is selected.
Please note: I tried this first with a UI Only model that had references to both the SF Account and Contact objects. I could not get this to work. Something is broken with our UI Only reference fields. You’ll have to do this against a real Salesforce object.
Please let me know if this helps…
@Rob_Hatch , thank you so much! That did the trick. I think my issue was that my filter was using “field from another model” and I was re-referencing my original model… rather than using “another field on row.” Makes sense that the model filter wasn’t working because changes hadn’t yet been committed… but the changes are available at the row level.
Anyhow, thanks for sending along the example and setting me straight!