The contacts in my database are 99% of the cases all residing in the same country. I have my postal codes from this country all in a table. In the contacts form, I want to create a combo box for the postal codes where the user can choose from so it will lookup the corresponding City and put it into the field 'City'. BUT, rarely I have a contact from another country (i can't collect all the postal codes from all different counties).i was thinking to create another postal codes table for the foreig contacts.
But how to catch this up in my combo box in the contacts form? And what kind of primary key should I use in the contacts table (was first thinking to use the postal code as a primary key or should I best use autonumber field)?
Thanks,
A.
But how to catch this up in my combo box in the contacts form? And what kind of primary key should I use in the contacts table (was first thinking to use the postal code as a primary key or should I best use autonumber field)?
Thanks,
A.