Lookup query allows me to retrieve up to two rows.

[Jon]

I'm trying to create a lookup query from Table A that includes three fields,
however, when using the wizard only two of the three fields show up.

Conceptually it's like this:

Car_sales_RRP (table)
Attributes:
....
Currency > Linked to table Currency (lookup table).
....

Currency (table)
Attributes:
Currency_ID
Exchange rate
Last_updated

I would like to view all three fields sorted by Last_updated in descending
order when lookup values from Car_sales_RRP.

Is this an Access 2007 issue? Any ideas?

 

[Lynn Trapp]

The lookup wizard in table design typically hides the primary key field. When
you step through the wizard there should be a checkbox that you can uncheck
for this purpose.

Having said that, you will probably find that you are much better off if you
will not use the table design lookup wizard and, instead, create a combobox
on a dataentry form