I am having some issues with my dropdowns. i would like to have 2 fields auto populate based off of another field. right now i have a table in my database that has every zip code with corresponding city and state. if i choose dependents under lookup wizard it takes an extremely long time for the page to load. i realize that the table has 42000 some records and that is the problem but is there away to have those 2 fields populate with having to have the enduser load all of them into memory?
thanks,
jm
