lookup wizard help!

[lan]

Hi,

I have two tables: tbl_A, tbl_B and a query qry_C basically just combine
some of the fields plus do some simple calculation for both tables. Now I
want to insert a lookup column in tbl_A to view some data from qry_C. From
lookup wizard, it shows “No valid fields can be found in “qry_Câ€. you may
have selected a query that uses the table you’re adding the lookup column to.
Please select a new sourceâ€. Does anyone can tell me that if this error is
normal for my particular situation? Or how can I avoid it?

Thanks very much!
Lan