City and State automatically populated by Zip Code

[Melch]

I'm trying to have the city and state fields in a clients file populated automatically by zip code, which I have working using lookups. The zip codes and their corresponding city and state are all stored in a separate zipcode file. But I wanted to add on some additional functionality by having the zipcode database self update.

Whenever a user enters in a zipcode in the zipcode field in the clients file, and tabs out of it, i have a script that kicks off. What I want the script to do is to check if that zipcode already exists in the zipcode database, and if it does not, prompt the user to create a new zipcode record in the zipcode file, and then bring the user to a layout to fill in the new data. When they click ok, another script will bring them back to the new record they were creating in the client file and that new zip will be populated in the zipcode field. If the zipcode they enter already exists, it will just validate it and leave it in the zipcode field, allowing the city and state to be looked up.

Hope that makes sense, sorry for bein so long winded, and I appreciate any insight anyone can lend me.

Thanks,

Melch

[alloyd]

Your biggest problem is that you want a script to kick in when you tab out of a field. The Troi Activator plugin (http://www.troi.com/software/activatordetails.html) should help you achieve what you want.