Combo Boxes in SQL Server?

[HenryE]

Hello,

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.

Henry

 

[Bensta]

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

 

[HenryE]

Thanks. I think I'm getting there now.

Henry