I've attached a file that works, but I was looking for a better, cleanre way.

One table is a zone chart, and one table are contacts.

My goal take, take a zip code 13587 and find out the corresponding zone. The Zones are referenced by 132-145, as in you only use the first number.

I made a script that worked, but as I was saying, is there a cleaner way?

148_Converted.zip

"as in you only use the first number"??? Do you mean first three numbers not first number???

If I understand correctly you want to:

- enter a ZipCode in the Tech table

- once a zip is entered you want to use the first three digits of the ZipCode to lookup the Zone in table 148 Converted.

If this is what you are after see the attached file. Note that the only zip codes that will work are ones that start with 245 thorugh 272.

Zip_to_Zone.zip

Thanks!

I never knew you could have multiple parts to a relationship! Wow.. that is realy going to come in handy..