I used a very painfull and well known here workaround until now to update the listing of a (target) linked field depending on the selection of another linked field.
But, I have a premium account and access to scripting.
I wonder if it’s possible to alter a view of the target linked field with a filter based on a common field value (existing in both tables) (and maybe other things but for instance just this).
I was thinking of it because we can restrict a linked field by a view.
In summary, it needs:
- know what is the value in the first linked field
- get the value of the common field
- alter the view of the target field by filtering with the previous common field value
So, is it doable with scripting ?
Thanks a lot for your thoughts.