Queries :: How To Reference Current Row In SQL String

How to reference current row in SQL string? I have a qst while using RowSource. I have 3 tables:

[1] CITY
col: _value _name

[2] STREET
col: _city _value _name

[3] ADDRESS
cal: city street

The problem ocurred when i designed ADDRESS table:

The RowSource of [city] is "SELECT _name, _value FROM CITY".

And I set the binding-column as 2, so that _name can be displayed and the real value is _value(integer).

But here comes the trouble: how can i set the RowSource of [street]?

The _value of STREET table depends on _city, and _city is _value in CITY table.

E.g. _name of STREET is "Wall Street" when (_city,_value) = (1,1),

But "Lincoln Avenue" when (_city,_value) = (2,1)

I want to use "SELECT _name, _value FROM STREET WHERE _city=CurrentRow.city" as RowSource, but what can replace the "CurrentRow"?