|
|
Posted by J.O. Aho on 06/10/06 17:53
Frankly wrote:
> "J.O. Aho" <user@example.net> wrote in message
> news:4f09geF1gcqe8U1@individual.net...
>> Frankly wrote:
>>>>> I tried this in Access with out any luck. i was able to create a combo
>>>>> box in a form with fields for Area and Zipcode.. however when i
>>>>> selected the Area it wouldnt automatically bring the zip code. in
>>>>> other forms i was able to include fields from other talbes that would
>>>>> get filled according to a selection i made in a combo box.
>>>> This requires some javascript coding too, if you want the zip code box
>>>> to be automatically filled when you entered the area. Otherwise if you
>>>> allow people to leave the box empty, you can let the receiving php page
>>>> to fetch the zip code (keep in mind that an area may have more than one
>>>> zip code, so it's really better to do it the other way around, fill the
>>>> zip code and let the php script fetch the area name from the database
>>>> and then save it into the row).
>>> I am not sure how i would create this table.
>> ZipTable
>> ZipCode AreaName
>
>
> I thought a table like this would create dupes.
> if i understand this correctly I could put multiple zip codes in a single
> column :).
Forgot to say
Seattle WA98108,WA98109,...
will be slower to search than
Seattle WA98108
Seattle WA98109
and the fist one makes you can't have real relations between the ZipTable and
other tables (JOIN won't work), so the later is always a better one.
//Aho
Navigation:
[Reply to this message]
|