Lookup in Queries

  • Thread starter Thread starter SeRene
  • Start date Start date
S

SeRene

Hi,

I have a field with a lookup data type. I created a query
based on that table but is it possible for me to have the
lookup capability in that query too? instead of only
having it in table format.

Thanks.
 
Hi,

I have a field with a lookup data type. I created a query
based on that table but is it possible for me to have the
lookup capability in that query too? instead of only
having it in table format.

Thanks.
Click to expand...

I'd recommend NEVER using this misdesigned, misleading, very limited
feature AT ALL; and I'd also recommend using table or query datasheets
only for debugging, using Forms for all routine interaction with your
date. Or, you can join the lookup table to your main table in the
Query design window and select fields from both tables.

If you insist, however, open the query in design view. Right
mouseclick on the field you want to be a Lookup; select Properties;
and change it to Combo Box on the "lookup" tab. Don't get upset if
(say) sorting by this field produces incorrect results, or if the
Reports or exports from this table contain numbers instead of the
looked up text - that's just how this dumb feature "works".
 
I'd recommend NEVER using this misdesigned, misleading,
very limited
feature AT ALL; and I'd also recommend using table or query datasheets
only for debugging, using Forms for all routine interaction with your
date. Or, you can join the lookup table to your main table in the
Query design window and select fields from both tables.

If you insist, however, open the query in design view. Right
mouseclick on the field you want to be a Lookup; select Properties;
and change it to Combo Box on the "lookup" tab. Don't get upset if
(say) sorting by this field produces incorrect results, or if the
Reports or exports from this table contain numbers instead of the
looked up text - that's just how this dumb feature "works".
Click to expand...
Hi John,

I've tried but i cant select my option from the combo box.
The status bar shows "The recordset is not updateable". Is
there any way i can select an option from the combo box in
the query??

Thanks.
 
I've tried but i cant select my option from the combo box.
The status bar shows "The recordset is not updateable". Is
there any way i can select an option from the combo box in
the query??
Click to expand...

Not if the query isn't updateable, no. A Combo Box is a tool to update
data in your table - and if the query cannot be updated it HAS NO USE.

Can you not simply create a Query joining the lookup table to your
table in order to see the value? That's what queries are FOR; this was
possible long before Lookup Fields (or even Access, for that matter)
existed. Just Join the table to your query, and see the data that you
want to see - you DON'T need a combo box to be able to do so!
 
Back
Top