Good morning,
I have a table with Jobs and each job is related to a specific year.
I would like to have a Drop down list in my Jobs layout that would filter all the jobs for the specfic year. I have tried to use Value lists and read the year data from a table. Both options and due to the fact that I have to select a Jobs table related field to use the Dropdown invalidates my attempts.
I would like to have a dropdown list that does not store anything and it just serves as a trigger to filter data. Is this possible? If so, how?
Thank you for your time in advance.
Nuno Neto