Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Combo Boxes in SQL Server?

Combo Boxes in SQL Server?

Combo Boxes in SQL Server?


I love the Access and ADP ability to use lookup tables as combo boxes.  I'm now trying to build a pure SQL Server database, but with ADP-type abilities, and I have no idea how to create combo box lookup tables.

You know how, in ADP's, in the table Design view, there are two tabs: Columns and Lookup, and you can go into Lookup and then choose Combo Box as the Display Control; well, in SQL Server table Design view, everything is the same, except there's no Lookup tab, so I can't do the combo box thing, at least not in the way I know.

Any ideas?

Thanks much.


RE: Combo Boxes in SQL Server?

Unfortunatly ADP does not provide you with the ability have lookup values right in the tablesince most queries are stored on server not locally like an Access MDB file. If your combo boxe lookup is going to be on a form then you could bound it to a view or stored procedure or simply a select statement.
I hope this will help

RE: Combo Boxes in SQL Server?

Thanks.  I think I'm getting there now.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close