Computing a Column

[Michael Williams]

Lets say I have a table with 4 columns:
Column 1 Label - Year
Column 2 Label - Team
Column 3 Label - Team_ID
Column 4 Label - Table_Lookup

I would like the 4th Column (Table_Lookup) to contain the values from Columns Year and Team. Example of how I would like to see the value of a record.
Column 1 - 1999
Column 2 - Dallas Convicts
Column 3 - 1234
Column 4 - 1999~Dallas Convicts

How would I go about doiing this in adminstrator

Thanks in advance