help needed for lookup wizard error

[lan]

Hi,

I have two tables. tbl_A contains key assignment information: person_ID,
room_numb, key_ID, assign_date. tbl_B contains key number information for
each room including room_numb, totkey_numb( total key number for each room).
In order to check if there is a key available for a particular room with
admin input data into tbl_A, I want a drop down box which shows how many keys
left for each room before the admin really assign a key to person. So, for
the purpose of above, I create a query called qry_C which basically just
combine some of the fields plus do some simple calculation for both tables.
(the query contains room_numb, totkey_numb, keys_assignedforeachroom,
keysleftforeachroom).
Then 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

 

[John Vinson]

Hi,

I have two tables. tbl_A contains key assignment information: person_ID,
room_numb, key_ID, assign_date. tbl_B contains key number information for
each room including room_numb, totkey_numb( total key number for each room).
In order to check if there is a key available for a particular room with
admin input data into tbl_A, I want a drop down box which shows how many keys
left for each room before the admin really assign a key to person. So, for
the purpose of above, I create a query called qry_C which basically just
combine some of the fields plus do some simple calculation for both tables.
(the query contains room_numb, totkey_numb, keys_assignedforeachroom,
keysleftforeachroom).
Then 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

Answered in your first thread (where you posted a Reply after having
trouble posting a new thread). No need to post your question three
times; it won't get a better or a faster answer.

John W. Vinson[MVP]