IMO, you should never ever use lookup fields in table designs.
http://www.mvps.org/access/lookupfields.htm.

You should be using forms for all user interaction with your data. Forms can
use combo boxes to display the related values.

--
Duane Hookom
Microsoft Access MVP


"Deeds37" wrote:

I have designed a table and in one field of the table I have used 'look up
wizard' to make a relationship with another table in the database. When I
open the table in datasheet view and click on the field with the 'Look up
relationship' it pulls information from the first column only, not the
second. The relationship of the tables are right, not sure why it is pulling
information from one column only. I would like it to pull from both columns
as the row information is related.