Lookup table and large data sets

[John M. Battista]

I am trying to move a set of source information out of a table into another
table because there is heavy repetition of data in this field. (about unique
entries to 110 records). However when i use a look-up field i can't see the
important part (the data associated with the source) if its in a memo field
and the limit on text fields (255 chars) is far too small (this is a
scientific paper reference).

any suggestions?

 

[John Vinson]

On Wed, 20 Oct 2004 12:43:04 -0700, "John M. Battista" <John M.

I am trying to move a set of source information out of a table into another
table because there is heavy repetition of data in this field. (about unique
entries to 110 records). However when i use a look-up field i can't see the
important part (the data associated with the source) if its in a memo field
and the limit on text fields (255 chars) is far too small (this is a
scientific paper reference).

any suggestions?

Well... don't use Lookup fields in tables. Ever.

See http://www.mvps.org/access/lookupfields.htm for a critique.

Instead, use a Query joining the source table to the table containing
the memo field.

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