In Access there was a wizard in table design where you could select the name of the record, the name would show in the table column but underneath the pk id number would be inserted into the record's field. Does SQL Server allow anything like that? Thanks in advance.