I am trying to connect to tables.

[ugogirl65]

I am trying to connect to tables. The first table contains basic
contact and address info. The second table, Zone has only two fields,
but it has 999 records all ready filled in. The first field zzip
contain the first three digits of us zip codes. The second field has
contains the numbers to the corresponding us zones. I want the Zone
table to look at the zip in the contact table and then supply the
corresponding zone number. I don’t want to store the zone info in the
contact table. I joined zip from the first table and zzip from the
second table and was able to make a sub form containg only the two
fields from the zone table, zzip and zone. I then added a tab control
to the bottom of my contact form and added the zone sub form to that.
The first contact record shows the correct zzip and zone for its area;
however the following records do not. I tried to make a query using zip
from the contact table and the zzip and zone from the second table and
it come out blank. Can some one please tell me what wrong? I have
already spent two days on this same problem.

Thanks