Hey everyone,
I need to make a dealer locator for a company. Just a drop down list to
select state then a list.
The question is how to best set up the database. I want the have dealer info
updatable via form, just fill out the fields..
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!
Is there a better way??
Thanks,
Jeff Fongemie
------------------------------------------------------------------------------
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.
