AppGini Community Forums

I need some guidance in the below scenario, please
- I make a table with a country name column and city name column
- User selects a country as a lookup field in the second table form (eg. select Australia)
- Then the below field "city" should only show cities in Australia as a dropdown.

How can I do this?
Can't use advanced lookup field SQL query since the record is still not entered to the database.

A little help, please.....

This is the best way to do it if anybody is interested

Courtesy of pböttcher

I don't see the "Filter by" option on my app. I'm using version 5.94 rev 1132

Found it!