Create lookup with more than 20 fields

[heik09]

I have a set of 90 standard titles, that don't change. I created a lookup
table with these 90 fields. When I try to create a lookup column for my form
(or table), the message says I can't have more than 20 fields. Is there any
better way I can accomplish this?

 

[tina]

well, don't create it in a table, first of all - use a form. next, does your
lookup *table* really have 90 FIELDS? or do you mean 90 records? i think we
need to understand the structure of this table before we can help you out.

hth

 

[KARL DEWEY]

I created a lookup table with these 90 fields.
Make that table with one field - Title - and 90 records, one for each title.