> Do I need a seperate table for each state, with each table having same
> columns: dealer_name, dealer_address, dealer_telnumber etc...
>
>
> This means making 52 tables! If I need to make a change I will need to
> change each table!
One table with the dealer name and address. Do your query to return results
if the value of the state field equals the state selected. BTW, there are
only 50 states if you are talking about the US..... anything else is a
territory.
There are a couple of tags out there that will do this by zip code, which
has much more mojo IMHO than just searching by state. You can find them here
http://www0101.allaire.com/developer/gallery/SearchResults.cfm?keywords=zipc
ode
HTH,
Steve
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
