I want to filter “Flat/Unit” dropdown column based on the “Status” of payment. So the drop down should only display “Flat/Unit” whose “Status” is “DUE” .I used SELECT expression for this which is working fine for new additions.
However, when I try to update a record, it says invalid entry as the
"Flat/Unit"s status for this specific column is changed to
“Clear” while addition.
Is there any way around it?