question on a field type

E

Edwin Merced

I created a look up field. I will look up the values in a table with only
one field called MEMO (which is memo type). When I run the look up wizard
the MEMO field does not show. What must I do to incorporate this memo field
type in my look up?
 
J

John Vinson

I created a look up field. I will look up the values in a table with only
one field called MEMO (which is memo type). When I run the look up wizard
the MEMO field does not show. What must I do to incorporate this memo field
type in my look up?
Click to expand...

You can't, and shouldn't.

See http://www.mvps.org/access/lookupfields.htm for a critique of the
Lookup field type.

If you want to see the memo field in conjunction with data in another
table, don't use the table datasheet - use a Query instead, joining
the two tables.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top