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.:)

If I understand your question properly you are confusing the functionality of Access and SQL Server.

Providing you have setup your SQL Server Database properly and linked the tables then a Combo Box will work the same.

I have had good luck developing without linked tables as of late, and was wondering if a neat Access feature could find it's way into SQL Server. It appears that the answer is no.

Well the feature you are talking about is an application form design feature and not a database feature. They are 2 totally seperate things and I wouldn't expect to see that functionality in SQL Server.