Kryptronic Software Support Forum
You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
#1 02-28-2012 10:28:40
- jensme
- Member
- Registered: 04-29-2010
- Posts: 392
State Abbreviations and Not Changing Database
I'd like to have my drop down menus use the abb column in the state/province table instead of the id column. Is there a way to do that without changing the id column?
Offline
#2 02-28-2012 14:51:42
- salesdesk
- Member
- Registered: 07-03-2008
- Posts: 147
Re: State Abbreviations and Not Changing Database
The best way to do this is to login to admin and access System | Database | Raw Database Admin then choose to update the core_tabledefs table. Locate the row where the tid = core_stateprov and choose to update row. Change the value for the tdisplay column to 'abb'.
Have fun and make a mess.
Jeff
Offline