I have a Access Table with two columns. Each column is defined a lookup
column with an underlying SQL query.

When a user selects a value for Column A, I'd like the lookup query in
Column B to show only values related to the value chosen for Column A. In
other words, I'm trying to code something like,

SELECT OtherTable.AttrX FROM OtherTable WHERE OtherTable.AttrY = ColumnA;

I can't seem to get the WHERE clause to recognize the value chosen for
Column A for the specific row of data being modified.

Is this a limitation of a lookup query in Access or I'm just missing
something?

Jim T