Thanks for the information, Roy. I went to the tables/queries under options and "ID,key,code and num" are listed under autoindex. Given that,zipcode should have automatically indexed with "code" in there but it didn't!
Any suggestions, or do I have to spell out...