Link to another record field - Filter

Hi all,

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

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.