Lookup Fields in SQL Server

I'm just starting to use SQL Server (2008) after years with MS Access. I've set up a series of parent-child tables; the primary key of the parent being the foreign key in the child table. In Access table datasheet view a foreign key field contains a dropdown box so that you can select the values. When I try to populate my tables in SQL Server I can't see any dropdown in the foreign key field.
TimHudspithAsked:
Who is Participating?
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
SQL Server tables do not have the ability to view foreign key data as a lookup / combo box like Access does.
0
 
Brian CroweDatabase AdministratorCommented:
SQL Server isn't designed for direct data manipulation via UI.  That's what an application is for.
0
 
TimHudspithAuthor Commented:
So if I used Access as the front-end (adp file) would the tables behave in the Access fashion?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.