Create lookup with more than 20 fields

  • Thread starter Thread starter heik09
  • Start date Start date
H

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?
 
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
 
I created a lookup table with these 90 fields.
Make that table with one field - Title - and 90 records, one for each title.
 
Back
Top