Cannot I write formula in the query, to give the detail of the selected object?
In the query, populate the data of the city Hamburg only, if Hamburg is selected in the drop down menu in the table.
Is there some way to achieve this?
I am trying to do it with the lookup table.