I need to filter the “link to another record” field depending on another field in my table.
Example : I have a link to my “article base” in my invoice table :
- if I have “door” in my “department field”, I want that the link only show me the door article, means the “door view” of my article base.
- If it’s “tile” in my “department field”, I only want to see the “tile view”.
I know I can half make it with the “limit to a view”, but it is not enough. I will have to create as much field as views, and it’s not really practical.
Thanks for your feedback