I am creating a database where one of the functions is to display a contact rep's address.
I have created tables for the different components of the address (i.e. States and Countries) and have set the relationships to the contact table as appropriate. In the states and countries tables there is a two letter unique identifier (primary key) and the full name similar to below.
In the contact table, is there a way to show the full name and not the 2 letter abbreviation? This isn't necessarily a problem for states but for countries it would be useful to have the full name.
I have created tables for the different components of the address (i.e. States and Countries) and have set the relationships to the contact table as appropriate. In the states and countries tables there is a two letter unique identifier (primary key) and the full name similar to below.
Code:
StateID State
AL Alabama
AK Alaska
In the contact table, is there a way to show the full name and not the 2 letter abbreviation? This isn't necessarily a problem for states but for countries it would be useful to have the full name.