AnsweredAssumed Answered

Really Long Value List? Maybe another approach

Question asked by stufigler on Apr 26, 2012
Latest reply on Apr 26, 2012 by philmodjunk

Title

Really Long Value List? Maybe another approach

Post

Did a search . . . couldn't find an answer . . hopefully someone can advise me on this one.

 

I'm working with a 10,000 name mailing list for a music company.

Usually, when one of the groups plays a concert, there's a mailing list signup form out on the table and, after people sign the lists, we have someone in the office enter the name/address/email/etc into the big database manually.

What we're looking to start doing is to have a laptop or iPad at the concerts where people can sign up for the mailing list. Then the next day, we can just import those records into the main database.  That's all easy to do.

One thing I was looking at is having a single "drop box" field for the City, State, and Zip Code.  I have a list of every zip code in the United States, with the city and state included. So, for example, if someone lives in Aimwell, Louisiana, they would click on this field and start typing their city name; as they type AIMWELL, LA  71401 would pop up in the box and they could select it and move on.

This is all easy to do EXCEPT that when I try to paste the list of city/state/zip into the "value list," it's WAY too big. (I get the 30,000 character limit warning.)

Anyone have an idea of how I could get this to work?

 

Thanks for your adice,

 

stu

 

There are 42741 entrees in the complete list. An example of section of the list would be:

ALPINE, WY  83128
ALPLAUS, NY  12008
ALSEA, OR  97324
ALSEN, ND  58311
ALSEY, IL  62610
ALSIP, IL  60803
ALSTEAD, NH  03602
ALSTON, GA  30412
ALTA VISTA, IA  50603
ALTA VISTA, KS  66834
ALTA, CA  95701
ALTA, IA  51002
ALTADENA, CA  91001
ALTADENA, CA  91003
ALTAIR, TX  77412
ALTAMAHAW, NC  27202
ALTAMONT, IL  62411
ALTAMONT, KS  67330

Outcomes