I have candidate profiles in which I am using an address field. I need to categorize candidates into different tiers based on zip codes. I have already set up a table for the zip codes and corresponding tiers, I just need a way to bring that information into the candidate's table based on the address. Is it possible to use the address field to reference the zip code table in some way, to bring in the tier information?
Zip Code Prefixes
Zip codes by State
HUD USPS ZIP Code Crosswalk Files
U.S. Zip codes and MSA's (Metropolitan Statistical Area)
I haven't tried this but I don't have time. Let us know if this works for you.
For example the zip code field for an address field called [Address] is
[Address : Postal Code]