worldcrafter
New member
- Local time
- Today, 15:39
- Joined
- Feb 9, 2004
- Messages
- 7
I have to keep track of people's addresses in a database, so I have 2 fields, one called "City", and another called "Zipcode".
Although I wouldn't know how to implement it, I figure there is a way to automatically update the Zipcode field if I enter the City, or vice versa. For example, if I were to type "Honolulu" into the City field, then the value of the Zipcode field would automatically be updated to "96818". I know it would be a bad idea for this example since Honolulu has more than one zipcode for the various areas of that city(OT I live in Hawaii), but for other cities that I am entering into my database, there is only one zipcode for those cities(e.g. "Mililani" city always has "96789" as its zipcode).
how can I go about setting up my DB to do this? Just looking for more ways to save myself from a few keystrokes. Thanks
Although I wouldn't know how to implement it, I figure there is a way to automatically update the Zipcode field if I enter the City, or vice versa. For example, if I were to type "Honolulu" into the City field, then the value of the Zipcode field would automatically be updated to "96818". I know it would be a bad idea for this example since Honolulu has more than one zipcode for the various areas of that city(OT I live in Hawaii), but for other cities that I am entering into my database, there is only one zipcode for those cities(e.g. "Mililani" city always has "96789" as its zipcode).
how can I go about setting up my DB to do this? Just looking for more ways to save myself from a few keystrokes. Thanks
