Create lookup with more than 20 fields

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?

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


"heik09" wrote in message
...
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?

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


"heik09" wrote:

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?