Refering to my example below. I am using a Combo-Box in a grid. I am storing a 2 digit code in the address type field. This works correctly now. This 2 digit code links to its description in the type table. I want to store the code in the address table, but I want to display the address description in the grid on the screen when it is not in focus.


Sample Situation

Address Table
Client ID
Address ID
Address Type N(2)
Line 1
Line 2
City
State
Zip Code

Address Types Table
Address Type N(2)
Address Description C(15)