I definitely agree with having the Code_ID field an Integer (and/or AutoNumber), especially when it becomes a foreign key. It gets kind of ugly dealing with user-entered values as the foreign...
I talked to a very talented Microsoft Sales rep. who designed extensive applications using SQL Server applications. We have three applications which all share common person/employee data tables and...