Load a drop-down list with predicate clause
I have a data modeling with tables Project -> Task -> Working Hours.
I want to insert a record on the layout Working Hours, but once I choose the field Project in a Drop-down list, the next field is required to choose a Task Name that is related to that project.
I wold like to have this field using a Drop-down list and load with only the tasks related to the project chosen before. Is it possible??
I already tried using the Value Lists but I cant added some "where clause" on this.
I dont see an easy solution, but any clue how I can implement this is very welcome?