> I would prefer that developers start using GUIDs/UUIDs as record keys.

CREATE TABLE
TUS_CODE(
CODE_KEY GUID NOT NULL PRIMARY KEY,
CODE_NAME VARCHAR( 10 )
);

CREATE TABLE SOMETHING(
SOME_KEY ...,
SOME_STATUS GUID NOT NULL,
constraint status_fk foreign key ( some_status ) references status_code ( code_key )
);

Need I say more?

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com