Hi everyone,
I have a model that shows employee information from my Company (e.g.: age, tenure, actual position, etc.)
We work with monthly data base updates. I have a Straight Table object that works as an employee list, and when I select a name from this list, the model will show their up-to-date information. For example, if I look myself up in this list, it will show my information as of September 2023.
Above this list I have a search object, but when I look for an employee using the search bar, it shows old information, specifically from December 2022.
Is there a way to ensure the search object always takes me to the latest data? I've tried adding the search function in the Straight table but that seems to be impossible. Drop-down selection doesn't work as well since it will show top management and the model is for employees of a certain Level and below.
Looking forward to your comments, thanks!