Referencing column in lookup cell in a query

[DRiggs]

How do I reference a column in a lookup cell in a query

For example, in a table, I have a lookup combo box cell with four columns. I need the query to look at the data in column 4 even though column 3 is what is shown in the lookup cell

I know that in a form I can reference a column in a combo box using =[cmb_name].[Column](3) but how is that translated to reference a table cell column in a query

TI

 

[Kelvin]

Just join the table that the lookup uses and refer to the column in that
table.

Kelvin

How do I reference a column in a lookup cell in a query?

For example, in a table, I have a lookup combo box cell with four columns.

I need the query to look at the data in column 4 even though column 3 is
what is shown in the lookup cell.

I know that in a form I can reference a column in a combo box using

=[cmb_name].[Column](3) but how is that translated to reference a table cell
column in a query?