If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Create lookup with more than 20 fields
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? |
#3
|
|||
|
|||
Create lookup with more than 20 fields
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? |
Thread Tools | |
Display Modes | |
|
|