Hi,
I have a JOIN between 2 tables. In the LISTVIEW i'he a filter and everything works very well, if I choose a value, I receive the filtered data correctly.
The problem is when I have to add a record to the 2 table.
In the second table there is a dropdown dynamically filled.
I have to use a WHERE clausule in this dropdown and it should be like " WHERE table.field = {chosen filter}" (the value of the filter of the JOIN LIST).
I have a JOIN between 2 tables. In the LISTVIEW i'he a filter and everything works very well, if I choose a value, I receive the filtered data correctly.
The problem is when I have to add a record to the 2 table.
In the second table there is a dropdown dynamically filled.
I have to use a WHERE clausule in this dropdown and it should be like " WHERE table.field = {chosen filter}" (the value of the filter of the JOIN LIST).