Posted by Frankly on 06/10/06 14:48

>> 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.
I guess allowing null would let some records have more zip codes than
others.
so i could have
Area, ZipCode1, ZipCode2, ZipCode3. I would also understand if you think
this is over my head.
So it might be better if i insert these things manually. I know it would
allow for more errors but even with out doing that the amount of help I will
need is more than i ever expected getting.
but then again when ever i did look to learn these things in the past i
never had any one to help explain
the explainations I didnt understand. I guess I can try and if need be just
add a Area and Zip code field to the buildings table later on :).. yep thats
the ticket.
time to start building :).
i did search for my web again today and it now says.
Coming Soon.. this is the home of a future MySQL Hosting Website.. :).

Frank

[Back to original message]