Zipcode/Postcode list problem

B

Brad Christie

I have the complete list of Australian postcodes. The list has State,
Locality and postcode. Some Postcodes cover multiple localities; which makes
for a 16,906 row list.

What I'm looking to do in my form, is have the user enter the postcode; this
would populate the read only State field and populate a locality drop-down
list box for the user to select.

The problem I'm facing is the workable limit (about 300) you can display in
a SharePoint list; at 5000 it's very very slow. So any postcode beyond the
first page returns no value for the drop-down.

Any ideas how I can work around this issue using only a SharePoint list?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Using a Secondary Data Connection (SharePoint List) for Drop Down List Box 4
How do I have postcodes and states entered automatically? 2
Auto Populate Fields based on Drop Down List Selection 2
Using SP List as Data Source 0
Infopath pulling values from SharePoint list 1
Drop Down List and SharePoint Problem 8
How to script drop down list box 2

Top