Public Sales Rep Lookup by Zip
I would like to have a one line form that asks for a zip code and then displays the appropriate sales rep assigned to that area. I have a database with the sales reps and their Zip ranges. For example:
Zip codes from 17701 to 18343 belong to Steve Stevenson .
Sales Rep Lookup
Please enter a Zip Code : ____________ (17701)
Steve Stevenson
Phone: (123) 456-7890
Fax: (123 456-7890