In my country we have states and then local provinces under each state.
I want to reflect this in the shipping address and billing address so the states are listed in a drop down just like countries. And then the user can select their local province after selecting a state.
I need some guidance on how to properly create the states and local provinces in the database and how to tell Magento to display them in the frontend.
Best Answer
follow this tutorial it may help you for adding new field
http://www.excellencemagentoblog.com/magento-add-custom-fields-checkout-page
or
http://indiestechtips.wordpress.com/2011/07/30/how-to-add-custom-field-in-the-billing-and-shipping-address-of-onepage-checkout-in-magento/
for adding states as it is already there in magento
follow these links.
How add indian State?
http://excellencemagentoblog.com/blog/2012/01/31/magento-add-state-country-indian-states/