Looking For ideas on State Abrreviations

[rdpress]

I am creating a data with that will be primarily names and addresses. (I can not forsee ever having addresses outside the USA). I am not certain of the best way to handle the 'State' field. Is it best to state up a TblState, with fields the abbreviation and maybe fullname. Would the Primary key be the abbreviation or an ID field (number, size byte). Then set up one-to-many relationship with the ables containing addesses.

Or should I simply put a text field, length of 2 in the address tables, with no relationships, and use the state table to populate the field via a combo-box?

Any ideas appreciated.

 

[r937]

don't bother with a numeric primary key for the state table, make it the 2-char state abbreviation

rudy

http://rudy.ca/