I have a table with the following structure:

FieldID, numeric, identity field, not null
OtherFieldID, numeric, not null

For historic reasons, my OtherFieldID needs to be a duplicate, 'fake'
identity field. I want to create a default value or formula that will
assign it the value that gets assigned to FieldID, which is the REAL
identity field. Is it possible to do this without triggers, using default
or formula?