View Single Post
  #1  
Old November 18th, 2009, 09:26 PM posted to microsoft.public.access.tablesdbdesign
Deeds37
external usenet poster
 
Posts: 9
Default Look up wizard in tables

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.