A rookie's first effort - I'm so proud :o)

[Guest]

Good question, I don't really know. As most people, particularly
residentail, will not likely know the +4 for their code, I don't see that
working.

I like your idea. It would be a bit advanced for a newbie, but
conceptually, you could test to see how many city names have the zip code,
then offer the user the choices.

 

[Guest]

Of course you are right about that. Oh, well. For once I thought I would not
have to use the AutoNumbers.

James, here is how to take care of that problem. We will just have to add
an PostalCodeID field as the Primary key with the data type as Autonumber to
the PostalCode Table.

When you create the query for the combo box make sure that the ID field is
the first column. In your combo box's Properties sheet, click the Format tab
and be sure that the Column Count number includes all of the query columns.

Here is a neat trick that works well: for the first number in the Column
Widths: set it to 0" like this: 0";0.7";1.5";1";1.5"
This way your Postal_Code combo box will display the zipcode instead of the
autonumber (which will be hidden).

If you have a zipcode that includes more than one city, you can add the same
zipcode with the different city to your table. That way you can choose the
correct city when you are selecting the zip code.

Thanks Klatuu,
Hunter57